Have Geek Brain

How can I delete an external user in oracle?

When I give ..

select * from dba_users; It will provide a list of users. There is a user on this list

username: first / dbgokul Password: EXTERNAL

Of course .. it was created by me by mistake. (Long).

Now I don't know how to delete this user.

kindly support me .. how to remove this user from the database .. ???

Thanks in advance.

0


a source to share


3 answers


remove custom frame "first / dbgokul";



+1


a source 


drop user <username> CASCADE;


CASCADE can be omitted if the user does not have any objects.

0


a source


If you supply an Oracle object name (including usernames) without quotation marks, Oracle looks for an uppercase name without special characters. For this reason, it is recommended that you do not use names or special names or special characters in your names for Oracle objects. Oracle can accept lower / mixed names and special characters if you quote around the names. See this example:

SQL> create user "first/dbgokul" identified by foo
  2  /

Gebruiker is aangemaakt.

SQL> select username from dba_users where username like 'fi%'
  2  /

USERNAME
------------------------------
first/dbgokul

1 rij is geselecteerd.

SQL> drop user first/dbgokul
  2  /
drop user first/dbgokul
               *
FOUT in regel 1:
.ORA-00921: Onverwacht einde van SQL-opdracht.


SQL> drop user "first/dbgokul"
  2  /

Gebruiker is verwijderd.

Regards, Rob.

0


a source






More articles:


All Articles