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
how can you initialize log miner?
What are the commands used in dcl? : sql server DBA
what is the use of ocr?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how does an oracle clusterware manage crs resources?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What is the default fill factor value? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
how can a session indicate its interest in receiving alerts?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What are the commands you'd issue to show the explain plan for "select * from dual"?