Sign Up Login


  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

What are the commands used in dcl? : sql server DBA

0 Answers  

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

0 Answers  

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

What is fill factor? : sql server DBA

0 Answers  

what is meant by gateway

1 Answers   IBM,

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

For more DB Administration Interview Questions Click Here
Categories