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

Question Posted / rajarengaiyan

4 Answers
6749 Views
Wipro, I also Faced
E-Mail Answers

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

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

What are the commands used in dcl? : sql server DBA

0 Answers

What is transparent data encryption? : sql server DBA

0 Answers

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

0 Answers

what is asm?

0 Answers Oracle,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

what is difference between user managed backup and rman backup?

1 Answers CTS,

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here