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
8691 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

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

2 Answers

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers

what is the use of home directory???

1 Answers HP,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

how can you schedule a job in database?

0 Answers Oracle,

Can we take incremental backups in datapump?

1 Answers

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers

what is a user-defined lock?

0 Answers Oracle,

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

For more DB Administration Interview Questions Click Here