RE: master DB users


Hi,

Please find answers to your questions:

1. In my company I have a standard that Restric Access to Master Database
(No user other than DBA should be allowed to access the master database).
I as a security engineer I have to check if the DB admins comply to this
standard.

2.I want to ensure that only database administrator has access to the Master
database.

Appreciate your cooperation.
"Mark Han[MSFT]" wrote:

Hi Josppy,

Thank you for the quick response.

To use a query to list the all user with theri permission is very
complexin. and to get that might not be helpful to your main concern. in
order to better assist you in the post, I would like to know the following
1 the reason for lising the all master db user with their permission.

2 what would you like to do after knowing all master db usesr with their
permissions?

Besides, I found that you submit an another post for the same issue. in
order to let us work more efficient, i will just send my reply in this
post. is it OK with you?

I look forward to your reply.

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... If the Master database is corrupt, how would you advise I maybe replace with ... "SQL Server cannot start the master database. ... MVP - Windows Live Platform ...
    (microsoft.public.sqlserver.server)
  • RE: master DB users
    ... (No user other than DBA should be allowed to access the master database). ... explicitly to database users in master, except those that SQL Server ... Those that are not in the sys schema ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot recover the master database.
    ... To fix a corrupted master database run rebuildm.exe. ... msdb and modle databases and replace them with blank ones. ... You do have a backup of your system databases, ...
    (microsoft.public.sqlserver.server)
  • Re: Looking for best solution
    ... If you have a master database, and want to "merge" changes into it, take a ... > ...currently the master table includes all customer data and the field rep ... would I then still use the replication method of updating the data ... >> Jeff Boyce ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to recover master database
    ... My database master was destroided, ... RESTORE DATABASE must be used in ... I need recover information about the aplicactions users. ... >> How Do I do to recover information from master database ...
    (microsoft.public.sqlserver.server)