Re: Lock out 1 user within Enterprise Manager
From: Bill Kenworthy (noreturn_at_hotmail.com)
Date: 02/23/04
- Previous message: CPS: "Lock out 1 user within Enterprise Manager"
- In reply to: CPS: "Lock out 1 user within Enterprise Manager"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Lock out 1 user within Enterprise Manager"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Lock out 1 user within Enterprise Manager"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 23 Feb 2004 08:07:39 -0800
Don't give the user sysadmin privileges on the database.
Make this person a member of the datareader role in the database they need
access to and no other role membership other than public and no permissions
explicitly.
Bill
"CPS" <anonymous@discussions.microsoft.com> wrote in message
news:14e2f01c3fa26$40d04c80$a001280a@phx.gbl...
> I have one rogue user who constantly creates, deletes,
> and just does things in the system that are not
> authorized causing tons of administrative work on my
> end. Is there a way to allow this user ONLY to READ
> everything from within SQL-EM, vs. writing or creating
> anything. All this person does is Crystal reports, so I
> might just remove the software altogether. But I'd like
> to restrict rights because they'll definitely come tell
> me that they couldn't do something due to restriction, at
> which point I can bust them. Thanks!
- Previous message: CPS: "Lock out 1 user within Enterprise Manager"
- In reply to: CPS: "Lock out 1 user within Enterprise Manager"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Lock out 1 user within Enterprise Manager"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Lock out 1 user within Enterprise Manager"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
