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

What is a correlated sub-query? : sql server DBA

574


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1855


what is a user-defined lock?

574


What is the importance of a recovery model? : sql server DBA

541


how can you enable flashback feature?

527






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.

1688


What is fill factor? : sql server DBA

630


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

552


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?

2378


what is ora 24313?what is the procedure to exclude that error?

2090


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

534


what is the use of ocr?

586


how can you implement fine-grained auditing?

594


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

2209


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2217