Drop any table ?? for user in different schema

[Ratzie]

Can I specifically allow a user to drop a table in a schema (specific schema) that he does not own.

I would perfer not to give him this drop any table that can be very nasty on any other table...

Oracle 10.2.0.2

[Paul Sperry]

DROP TABLE needs ALTER permission on the schema to which the table belongs, CONTROL permission on the table, or

membership in the db_ddladmin fixed database role.



USE dbname

GRANT ALTER ON OBJECT :: tablename TO username;

GO;

[Yogeeraj_1]

hi,

You may also try implementing Proxy User.

SQL> show user
USER is "SCOTT"
SQL> alter user yogeeraj grant connect through scott;

User altered.

SQL> connect scott[yogeeraj]/tiger
Connected.
SQL> show user
USER is "SW1"
SQL>

hope this helps!
kind regards
yogeeraj

[Srikanth Arunachalam]

Hi Ratzie,

Is your flashback feature is set on. If you have FLASHBACK feature on, you need not worry about user droping table. It will be placed in recyclebin from where you can restore it.

Plz let me know if you want more information on this.

Thanks,
Srikanth

[Yogeeraj_1]

hi again,

sorry for the typing mistake in my previous post which should instead read as follows:

SQL> show user
USER is "SCOTT"
SQL> alter user yogeeraj grant connect through scott;

User altered.

SQL> connect scott[yogeeraj]/tiger
Connected.
SQL> show user
USER is "YOGEERAJ"
SQL>

kind regards
yogeeraj

[Ratzie]

THanks guys, we have forced the user to log in with the appropriate user account