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 are the different types of upgrades that can be performed in sql server? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is the role of dip user in our database?
what is the use of recording information about current session?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how can a session indicate its interest in receiving alerts?
What is the importance of a recovery model? : sql server DBA
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.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you initialize log miner?
how can you record information about current session?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?