Home » RDBMS Server » Server Administration » restricting the user from performing DDL Activities
restricting the user from performing DDL Activities [message #62934] Wed, 25 August 2004 01:40 Go to next message
kiran
Messages: 503
Registered: July 2000
Senior Member
hi ,

 after revoking create any table privilege from a user,but still he is able to drop the table .i want to restrict the user from performing any DDL activites .

can we restrict the user from performing DDL activities without any triggers , is there any other way of doing this .

please provide a solution other than triggers ,

thanks

kiran

Report message to a moderator

Re: restricting the user from performing DDL Activities [message #62936 is a reply to message #62934] Wed, 25 August 2004 02:01 Go to previous messageGo to next message
nabila
Messages: 13
Registered: April 2003
Junior Member
revoke connect,resource and grant him just create session.

Report message to a moderator

Re: restricting the user from performing DDL Activities [message #63029 is a reply to message #62936] Thu, 02 September 2004 12:32 Go to previous message
Vaag
Messages: 9
Registered: August 2004
Junior Member
Use Product_user_profile table to restrict the drop table privelige being used by the user.

Hope it helps
Vaag

Report message to a moderator

Previous Topic: oracle database connection with 2 different instance on different host
Next Topic: 8i enterprise manager problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:30:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.