1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / ramesh

Grant Create session to <UserName>

Is This Answer Correct ?    10 Yes 2 No

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

Answer / sweta

Grant connect,create session to <username>;

Is This Answer Correct ?    6 Yes 0 No

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

Answer / kunal sain

grant connect,resource to username

Is This Answer Correct ?    7 Yes 3 No

Post New Answer

More DB Administration Interview Questions

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1 Answers   Oracle,

what is logical system in sap basis

1 Answers  

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

Where do you find the default index fill factor and how to change it? : sql server DBA

1 Answers  

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

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

1 Answers  

what is the role of dip user in our database?

1 Answers  

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?

1 Answers  

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories