You cannot remember what permissions that the db

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You cannot remember what permissions that the db_accessadmin fixed database role has ...

You cannot remember what permissions that the db_accessadmin fixed database role has and Books Online is not installed on your laptop. You're working on the SQL Server 2000 security roles for a client and need to get the document finished and the ISP is down. How can you quickly determine the permissions for this role?

Answer: Run sp_dbfixedrolepermission

Explanation: While creating an account and trying all permissions will work, it's not a quick way to do it. The sp_dbfixedrolepermission stored procedure will give you a list of permissions.

(Continued on next question...)

Other Job Interview Questions

• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• What is the result of the following query?
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• you want to be sure that SQL authenticated logins must abide by the password policy.. .
• Which of the following statements best describes the filter capabilities of Report Builder?
• Yesterday's QOD How are comments denoted in an XML document?
• How can you determine which Service Broker ports are being used on your server?
• Where does Profiler store its temporary data in SQL Server 2005?
• More...