1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

now one user in online.now i want drop him..how do u drop him?

Question Posted / rajarengaiyan

Answers were Sorted based on User's Feedback



now one user in online.now i want drop him..how do u drop him?..

Answer / kittu

Hi,

First query

select username, sid#, serial from v$session where
username='ur_username';

if rows are get selected, then kill the process, by issuing
following statement:

alter system kill session 'sid, serial#';

after that issue the following statement:

drop user username cascade;

Is This Answer Correct ?    9 Yes 0 No

now one user in online.now i want drop him..how do u drop him?..

Answer / raja

DROP USER 'USER_NAME' CASCADE;

Is This Answer Correct ?    4 Yes 3 No

now one user in online.now i want drop him..how do u drop him?..

Answer / vikram

Remove from masseger or else tell him logout fom massenger.

Is This Answer Correct ?    2 Yes 2 No

now one user in online.now i want drop him..how do u drop him?..

Answer / suman

DROP USER USERNAME CASCADE;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

Why does Oracle not permit the use of PCTUSED with indexes?

1 Answers  

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1 Answers  

what is the use of recording information about current session?

1 Answers   Oracle,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

what is difference between user managed backup and rman backup?

1 Answers   CTS,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

What is the difference between dropping a database and taking a database offline? : sql server DBA

1 Answers  

what is logical system in sap basis

1 Answers  

when does an alert gets signaled?

1 Answers   Oracle,

How do you tell what your machine name is and what is its IP address?

4 Answers  

For more DB Administration Interview Questions Click Here
Categories