OraFAQ Forum: Server Administration » How do to drop loggin ?

Home » RDBMS Server » Server Administration » How do to drop loggin ?

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

How do to drop loggin ? [message #58686]

Thu, 25 September 2003 14:48

Antonio Marcos Souza
Messages: 13
Registered: September 2003

Junior Member

Hello, can I drop loggin in Oracle, or loggin is the user ?

Report message to a moderator

Re: How do to drop loggin ? [message #58688 is a reply to message #58686]

Thu, 25 September 2003 15:08

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Antonio,
'Logins' is used in SQL*Server to denote users connecting to SqlServer instance. In Oracle,we call them as just Users,which is similar to SqlServer 'users'. We dont create logins like SqlServer.

To drop the user,

Drop user 'username';
if the user does not contain any objects.

Drop user 'username' cascade;
if the user owns any database objects.

Think twice before dropping 'user' in Oracle,becos they are not similar to 'logins' as in sqlserver.

HTH
-Thiru

Report message to a moderator

Previous Topic:	Create Loggin via-commands.
Next Topic:	System tablespace full

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:44:38 CDT 2024