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

Question Posted / rajarengaiyan

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

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

Explain the concept of the DUAL table.

3 Answers

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers TCS,

How to determine the service pack currently installed on SQL Server?

1 Answers

When a user process fails, what background process cleans up after it?

1 Answers

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

deleted of control file how will u recover control file?

4 Answers CTS,

What is the difference between Datapump & export/import?

2 Answers

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers Cognizant,

For more DB Administration Interview Questions Click Here