Home » RDBMS Server » Security » Grant
Grant [message #19250] Wed, 06 March 2002 20:20 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 11:28:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.