When creating a user, what permissions must you grant to
allow them to connect to the database?

Answer Posted / ramesh

Grant Create session to <UserName>

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

580


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1493


How do you open a cluster administrator? : sql server DBA

581


What are the different ways you can create databases in sql server? : sql server DBA

599


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

3803






internal architecture

1755


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1541


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2031


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

514


how can you connect from 10g user to 11g user??

1681


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2230


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1973


What would you do with an "in-doubt" distributed transaction?

1419


what are the differences of where and if in SAS?

1664


What is transparent data encryption? : sql server DBA

564