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

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

What is the default port no on which sql server listens? : sql server DBA

0 Answers  




What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

What is fill factor? : sql server DBA

0 Answers  

Explain the difference between a data block, an extent and a segment.

2 Answers  

How to start SQL Server in minimal configuration mode?

1 Answers  

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

Hot backup procedure?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories