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

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

Question Posted / guest

3 Answers
8853 Views
I also Faced
E-Mail Answers

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

how can a session indicate its interest in receiving alerts?

0 Answers Oracle,

What is replication? : sql server DBA

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

Name two files used for network connection to a database.

5 Answers

What authentication modes does sql server support? : sql server DBA

0 Answers

What are the recovery models for a database? : sql server DBA

0 Answers

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here