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
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what is the use of ocr?
internal architecture
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can you redefine a table online?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different types of indexes available in sql server? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What would you do with an "in-doubt" distributed transaction?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you process messages in order asynchronously?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what are the benefits of flashback feature?