Permissions for EM



What permissions are needed to utilize Enterprise Manager?

Long story, but public role has all rights revoked, so I want to create a
new database role that has access to what it needs to get into the EM.


.



Relevant Pages

  • Re: Read/Only access to Northwind database
    ... is a special database role to which every database ... The public role contain default access permissionsfor any ... Microsoft MSDN Online Support Lead ... response from the community or a Microsoft Support Engineer within 1 ...
    (microsoft.public.sqlserver.security)
  • Re: change user1 access changes user2 access
    ... Using the public role is your problem. ... All users, whether it be User1, ... permission you are granting All users the permissions. ... > name, a password, I select a database to login to, then go ...
    (microsoft.public.sqlserver.security)
  • Re: SMS View Tables access through ODBC - Help!
    ... > view tables is required for a feed to a third party asset management tool. ... Is public role necessary to access view tables? ... with a standard user account to make sure that nothing bad happened. ... enable the select permissions to the objects you want them to view. ...
    (microsoft.public.sms.admin)
  • Re: change user1 access changes user2 access
    ... > Using the public role is your problem. ... >permission you are granting All users the permissions. ... I click on New Login. ... >> name, a password, I select a database to login to, then ...
    (microsoft.public.sqlserver.security)
  • Re: Public Role in SQL Server 2000 SP3
    ... >The default permissions of the public role allow SELECT ... control security by user ... >> If I add a user to a database with Public Database ...
    (microsoft.public.sqlserver.server)