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

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

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  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  




what is a crs resource?

0 Answers   Oracle,

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

What the different types of replication and why are they used? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories