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

Question Posted / rajarengaiyan

4 Answers
5118 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

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

which background process will run @ the time of creation of catalog database

1 Answers CSC,

How would you go about generating an EXPLAIN plan?

2 Answers

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

3 Answers

What is checkpoint?

3 Answers Accenture,

what is the use of recording information about current session?