Re: securityadmin

Hi
After moving them to the logical choice of securityadmin, EM reports errors
about not having access to select data from syslogins and such.
Can you elaborate a little bit what does it mean?

Might I ask how any of you have addressed this sort of scenario, where you
have DBA's and security administrators as separate entities?


No at our shop, however, there is security admin server role.
Read about Fixed Server Roles in the BOL




"A McGuire" <allen.mcguire@xxxxxxxxxxxxxxxxx> wrote in message
news:%23k$rJZeoGHA.4404@xxxxxxxxxxxxxxxxxxxxxxx
At the company I work for, we have security personnel that handle
assigning privileges to databases and object. The security personnel
themselves used to be in the sysadmin fixed server role. After moving
them to the logical choice of securityadmin, EM reports errors about not
having access to select data from syslogins and such.

Might I ask how any of you have addressed this sort of scenario, where you
have DBA's and security administrators as separate entities?

Allen



.

Relevant Pages

  • User-managed universal groups
    ... We currently have some existing universal groups that users maintain by ... As security administrators, we're pondering the ...
    (microsoft.public.windows.server.active_directory)
  • Re: securityadmin
    ... add the database user to db_datareader, ... fixed server role Security Administrators. ... I can go ahead and add that login as a database user and add them ...
    (microsoft.public.sqlserver.security)
  • Re: securityadmin
    ... grant that role access to each database, ... No at our shop, however, there is security admin server role. ... Read about Fixed Server Roles in the BOL ...
    (microsoft.public.sqlserver.security)
  • RE: troubleshuting with conect SQL server with Delphi
    ... goto the security and set the server role to the user. ...
    (microsoft.public.sqlserver.odbc)