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
what are the differences of where and if in SAS?
Which autogrowth database setting is good? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is a system database and what is a user database? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are statistics, under what circumstances they go out of date, how do you update them?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the commands used in dcl? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is fill factor? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What is the default fill factor value? : sql server DBA