Re: Permissions for EM
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Fri, 14 Jul 2006 07:34:23 -0700
As long as the user has server login priviliges, they 'should' be able to
use EM. And they will have access to any object with public
permissions -including any other db on the server that allows public access.
(Northwind and Pubs are allow Public access to everything, so they should be
removed from production servers.)
Then to access a specific db, they need to be provided access to the db, and
put in the desired role.
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"A McGuire" <allen.mcguire@xxxxxxxxxxxxxxxxx> wrote in message
news:u6rZf10pGHA.3584@xxxxxxxxxxxxxxxxxxxxxxx
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.
.
- Follow-Ups:
- Re: Permissions for EM
- From: A McGuire
- Re: Permissions for EM
- References:
- Permissions for EM
- From: A McGuire
- Permissions for EM
- Prev by Date: Re: Limiting a user to only executing a stored only that access anothe
- Next by Date: Re: Permissions for EM
- Previous by thread: Permissions for EM
- Next by thread: Re: Permissions for EM
- Index(es):
Relevant Pages
|
