When creating a user, what permissions must you grant to
allow them to connect to the database?
Answer Posted / sweta
Grant connect,create session to <username>;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
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
What happens on checkpoint? : sql server DBA
Can you redefine a table online?
what is a user-defined lock?
how can you communicate with operating system files from oracle?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different types of indexes available in sql server? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what functionality does oracle provide to secure sensitive information?
What is fill factor? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?