OraFAQ Forum: Security » Enable Drop

Home » RDBMS Server » Security » Enable Drop

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

Enable Drop [message #160384]

Fri, 24 February 2006 21:43

orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad

Senior Member

I have disabled a user to drop any table by PUP table through sys user...but im unable to enable it back using the same query..can any suggest

Report message to a moderator

Re: Enable Drop [message #160396 is a reply to message #160384]

Sat, 25 February 2006 00:53

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I do not understand what you did and what you want to do?

Post back command that you ran.

Report message to a moderator

Re: Enable Drop to any user [message #160418 is a reply to message #160396]

Sat, 25 February 2006 06:38

orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad

Senior Member

I have ran insert query to disable Drop query to Scott table...but im unable to enable it back...suggest me plz..i ran this query through a DBA user. now i cant drop any table in scott, but how to enable it...well i changed disabled to enable but not effective.

>insert into product_user_profile values
('SQL*PLUS' , 'SCOTT' , NULL,'DROP',NULL,'DISABLED',NULL,NULL);

Report message to a moderator

Previous Topic:	DBA role
Next Topic:	Alter username

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 20:08:59 CST 2024