Do anyone know that how to avoid drp and truncate command in PLSQL DEVELOPER

[MIFI]

In sqlplus we use the table product_user_profile to insert name of schema and command to disable drop and truncate command in that user.

Can we disable truncate and drop for user in User's own object in PL/SQL Developer

 

[Marco Kalter]

You can use the Authorization feature to enable/disable PL/SQL Developer functionality. Similar to the product_user_profile, this creates and populates a plsqldev_authorization table which allows you to grant functions to roles or users.