yesterday, I caused mayhem by accidentally truncating the wrong table. I know, a stupid mistake, but it happens!
I checked out the TOAD help and learnt that the truncate and drop buttons can be disabled by adding "ALLOW_DROP_TBL=0" to your TOAD.ini file. This is great as now developers must type in the SQL command 'truncate table_name;', making us slightly more aware of what we are doing.
My question is can I now create a user that does not have the power to truncate/drop tables. It would be very useful to have such users with only select/insert options.