Home » RDBMS Server » Server Administration » Droping user....
icon5.gif  Droping user.... [message #180079] Fri, 30 June 2006 02:13 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
I have created an DataBase user called "AS"...The problem is that I can not drop it because "AS" is an reserved word so the server does not accept the following expresion "drop user AS"...Is there any way to drop this user???

Report message to a moderator

Re: Droping user.... [message #180083 is a reply to message #180079] Fri, 30 June 2006 02:19 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Try
SQL> drop user "AS"

Report message to a moderator

Re: Droping user.... [message #180097 is a reply to message #180083] Fri, 30 June 2006 02:45 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
dROP FROM ORACLE ENTERPRISE MANAGER

Report message to a moderator

Re: Droping user.... [message #180294 is a reply to message #180097] Sun, 02 July 2006 23:14 Go to previous message
imtj
Messages: 12
Registered: July 2006
Location: Chinese
Junior Member
Because word "AS" is oracle databse's key word.
So You can't input command 'sql> drop user as'.
Try
SQL>drop user "as"

Report message to a moderator

Previous Topic: How to add tablespace or datafile in Disaster recovery server (Oracle8.1.6) in Solaris 5.8
Next Topic: Running prvtfile.plb
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:27:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.