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

Question Posted / rajarengaiyan

4 Answers
6614 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 are the commands used in dcl? : sql server DBA

0 Answers

how can you process messages in order asynchronously?

0 Answers Oracle,

what are the benefits of flashback feature?

0 Answers Oracle,

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

what is incremental checkpoint?

1 Answers CTS,

what is grd?

0 Answers Oracle,

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

how will you see when the database was started using sql prompt?

2 Answers IBM,

Can you redefine a table online?

0 Answers Oracle,

how do see how much space is used and free in a tablespace

2 Answers Genpact,

For more DB Administration Interview Questions Click Here