Home » RDBMS Server » Security » Enable Drop
Enable Drop [message #160384] Fri, 24 February 2006 21:43 Go to next message
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
Re: Enable Drop [message #160396 is a reply to message #160384] Sat, 25 February 2006 00:53 Go to previous messageGo to next message
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.
Re: Enable Drop to any user [message #160418 is a reply to message #160396] Sat, 25 February 2006 06:38 Go to previous message
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);

Previous Topic: DBA role
Next Topic: Alter username
Goto Forum:
  


Current Time: Fri Mar 29 02:02:11 CDT 2024