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

Answer Posted / sweta

Grant connect,create session to <username>;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1726


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1983


which background process invoke at the time of upgradation tell me???

2227


What are the steps you will take to improve performance of a poor performing query?

2421


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2391






What the different types of replication and why are they used? : sql server DBA

563


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

564


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3944


when does an alert gets signaled?

580


what is a crs resource?

600


What is the default port no on which sql server listens? : sql server DBA

558


What are the different types of upgrades that can be performed in sql server? : sql server DBA

680


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

1745


how does an oracle clusterware manage crs resources?

572


Where would you look for errors from the database engine?

2355