Home » RDBMS Server » Server Administration » Setting previliges for user account with Oracle10g
Setting previliges for user account with Oracle10g [message #149972] Mon, 05 December 2005 19:59 Go to next message
rhythmd77
Messages: 2
Registered: December 2005
Location: Malaysia
Junior Member
Hi,

I have created an account call test on Oracle10g..I just gave it create table and alter table previleges and of course the select_catalogue_role and select any dictionary previleges..the thing I don't understand is how come I still can drop the table even though I didn't give that previliges. Could some tell me what am I to do if I don't want to allow the user to drop the table but just create and alter.

someone please help

Report message to a moderator

Re: Setting previliges for user account with Oracle10g [message #149989 is a reply to message #149972] Mon, 05 December 2005 22:45 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

As i remember if you have the "create table" privilege then you can also drop those tables.

No need to explicitly grant "drop table" privilege.

Topic still open for discussions.

Report message to a moderator

Re: Setting previliges for user account with Oracle10g [message #150002 is a reply to message #149972] Mon, 05 December 2005 23:32 Go to previous message
rhythmd77
Messages: 2
Registered: December 2005
Location: Malaysia
Junior Member
Yeah I know but this case is that I don't want the user to drop the table but thats impossible to prevent rite..? I know that base on the select_catalogue_role allows the table to be drop but I don't want that to be done.

Report message to a moderator

Previous Topic: Set up two different Oracle Home
Next Topic: ORA-12560: TNS:protocol adapter error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 13:29:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.