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
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.
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.
Previous Topic: Security - Public Objects
Next Topic: Database links and security
Goto Forum:
  


Current Time: Thu May 26 15:40:43 CDT 2022