| temo |
Posted: Jul 03, 2008 09:26:46 AM |
Total Post: 6
Joined: Jan, 2008
|
i want to revoke drop table prevlige from all user's
thank's |
|
|
 MOH_DBA |
| Posted: Jul 03, 2008 03:15:45 PM |  |
|
Total Post: 133
Joined: Nov, 2007
|
if the user create the table you cannot revoke drop from him, but you can create database trigger that audit or prohibit dropping tables.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm
|
|
|
|
|
| positive |
| Posted: Jul 04, 2008 12:53:49 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Gitesh |
| Posted: Jul 04, 2008 02:56:09 AM | |
|
Total Post: 322
Joined: May, 2005
|
You can restrict DROP command for particular user using profile table.
|
|
|
|
|
| Babu |
| Posted: Jul 05, 2008 06:54:52 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
You can restrict throw DATABASE TRIGGER (Before Drop0
Babu
|
|
|
|
|
| temo |
| Posted: Jul 12, 2008 07:40:22 AM | |
|
Total Post: 6
Joined: Jan, 2008
|
dear - gitesh -
how i can restrict DROP command for particular user using profile table ?
thank's
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
