OraFAQ Forum: Security

Home » RDBMS Server » Security » Grant

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant [message #19250]

Wed, 06 March 2002 20:20

Amita Kapadia
Messages: 8
Registered: January 2002

Junior Member

Dear All,

Can you tell me which GRANT should be given to user so that he can truncate the table. delete grant on that table is already given still truncate table is not working.

Amita

Report message to a moderator

Re: Grant [message #19252 is a reply to message #19250]

Wed, 06 March 2002 22:00

Srinivas
Messages: 138
Registered: June 2000

Senior Member

grant drop any table privilege to the user.

Report message to a moderator

Re: Grant [message #19254 is a reply to message #19250]

Wed, 06 March 2002 22:26

seng
Messages: 191
Registered: February 2002

Senior Member

you are only allow to TRUNCATE the table if the user is the owner of this table or granted DROP ANY TABLE privilege.

Report message to a moderator

Previous Topic:	Security - Public Objects
Next Topic:	Database links and security

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 09:31:31 CDT 2025