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

Answer Posted / kunal sain

grant connect,resource to username

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1645


What are the recovery models for a database? : sql server DBA

683


How do you troubleshoot errors in a sql server agent job? : sql server DBA

673


What would you do with an "in-doubt" distributed transaction?

1495


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

2089






What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

633


What is the default fill factor value? : sql server DBA

671


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

685


What is dcl? : sql server DBA

751


when does an alert gets signaled?

672


How do you trace the traffic hitting a sql server? : sql server DBA

939


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

1806


what is logical system in sap basis

1240


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

1599


Why would you call update statistics? : sql server DBA

652