Re: Lock out 1 user within Enterprise Manager

anonymous_at_discussions.microsoft.com
Date: 02/23/04 

Date: Mon, 23 Feb 2004 14:24:15 -0800

Thanks!! How do I make sure they don't go into EM and
give themselves the rights back again?
>-----Original Message-----
>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!
>
>
>.
>

Relevant Pages

  • Re: Lock out 1 user within Enterprise Manager
    ... Don't give the user sysadmin privileges on the database. ... Make this person a member of the datareader role in the database they need ... > to restrict rights because they'll definitely come tell ...
    (microsoft.public.sqlserver.security)
  • Re: Find a record when Form opens
    ... You create a new User so he can use the database. ... If you have the president's user account as a member of different ... groups, you can give him different rights, and use a function or ... do, and it would look just like a normal Access DB, but they can only ...
    (comp.databases.ms-access)
  • Users and Groups
    ... I have a database where I need to create 2 different groups which has ... different Access type. ... will become the member of "Users" group, ... not have the rights. ...
    (microsoft.public.access.security)
  • Re: Users and Groups
    ... Have you given your groups permissions to the 'Database' object? ... > will become the member of "Users" group, ... > not have the rights. ...
    (microsoft.public.access.security)
  • Re: DC v Heller: Amicus Brief of the Real Linguists, Part I
    ... Otherwise, a foreigner like Verdugo could, but Rehnquist rightly pointed out that as he was NOT a member of THE PEOPLE CLASS, he could NOT claim the right, even though he IS an individual, but NOT AN INDIVIDUAL MEMBER OF THE PEOPLE. ... But, as Rehnquist points out, the rights of the 4th Amen extend ONLY to THE PEOPLE! ... How would an 80-year-old black woman from Haiti having an "individual right" to "own and carry guns" further the security of a free state to have a well-regulated militia, when such a person would be FOUR WAYS prohibited from SERVING in the militia or VOTING for the legislature that organizes and controls it? ... OR, and this is where the BoR comes in, any rights they MAY have claimed were not PROTECTED or GUARANTEED by the Constitution! ...
    (talk.politics.guns)