|
|
| Re: Revoke Truncate from Owner of the Table [message #52025 is a reply to message #52021] |
Wed, 26 June 2002 15:01   |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
To alow a user to truncate a table not owned by themselves requires "grant drop any table" priv. From that I conclude that "truncate" in bundled into the same priv. category as "drop", so if they can drop a tabe they can truncate one too.
|
|
|
|
| Re: Revoke Truncate from Owner of the Table [message #52037 is a reply to message #52025] |
Thu, 27 June 2002 07:41 |
johnk
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Yes.. you are partly right..
one should be the OWNER or have DELETE ANY TABLE privilege or DROP ANY TABLE..
But..How do you prevent the Owner of the Table the DROP Priv or DELETE Priv.
I can prevent DELETE priv on the OWNER by using ORACLE's POLICY's..But not the DROP priv...
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
