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
8841 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 would you go about verifying the network name that the local_listener is currently using?

0 Answers

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

What is the dataguard background process??

1 Answers iGate,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

What is the importance of a recovery model? : sql server DBA

0 Answers

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

How would you determine the time zone under which a database was operating?

2 Answers

who owns the operating system files created by the utl_file package?

0 Answers Oracle,

Give two examples of referential integrity constraints.

2 Answers

For more DB Administration Interview Questions Click Here