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

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

How to make a replica of existing oracle server to another server?

3 Answers  

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

Which environment variables are absolutely critical in order to run the OUI?

2 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?

0 Answers  




Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

How would you go about generating an EXPLAIN plan?

2 Answers  

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

1 Answers   CTS,

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

For more DB Administration Interview Questions Click Here
Categories