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 sql server versions you have worked on? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is logical system in sap basis
how can you communicate with operating system files from oracle?
. 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?
What is a correlated sub-query? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the recovery models for a database? : sql server DBA
What is transparent data encryption? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what are the performance views in an oracle rac environment?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.