Home » RDBMS Server » Security » Revoke Truncate from Owner of the Table
Revoke Truncate from Owner of the Table [message #52021] Wed, 26 June 2002 12:29 Go to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Does anybody has successfully implemented "Revoke Truncate from Owner of the Table"

John K
info@itconrads.com
Re: Revoke Truncate from Owner of the Table [message #52025 is a reply to message #52021] Wed, 26 June 2002 15:01 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: DBMS_OBFUSCATION_TOOLKIT
Next Topic: Insuff Privs for a View
Goto Forum:
  


Current Time: Mon Oct 18 05:43:50 CDT 2021