now one user in online.now i want drop him..how do u drop him?
Answer Posted / raja
DROP USER 'USER_NAME' CASCADE;
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
how can you schedule a job in database?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What would you do with an "in-doubt" distributed transaction?
What the different topologies in which replication can be configured? : sql server DBA
when does an alert gets signaled?
Why would you use sql agent? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how can a session indicate its interest in receiving alerts?
how can you get actual data change values from previous transactions in oracle?
How would you extract DDL of a table without using a GUI tool?
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
How would you go about verifying the network name that the local_listener is currently using?
What is the importance of a recovery model? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA