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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can a session indicate its interest in receiving alerts?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Why would you call update statistics? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the commands used in dcl? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Why does Oracle not permit the use of PCTUSED with indexes?