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


Please Help Members By Posting Answers For Below Questions

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1505


Why would you use sql agent? : sql server DBA

588


how can you record information about current session?

503


What is the default port no on which sql server listens? : sql server DBA

568


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?

2981






what are the benefits of flashback feature?

599


what is the use of ocr?

606


What are the different sql server versions you have worked on? : sql server DBA

551


what are the types of connection load-balancing?

570


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1754


What is dbcc? : sql server DBA

786


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

668


What is fill factor? : sql server DBA

658


How would you go about verifying the network name that the local_listener is currently using?

2768


Query processing is slow(eg select query)how will u solve that

6543