Re: CLIENT PERMISSION

From: Muhammad Saleem Usmani (msusmani_at_yahoo.com)
Date: 04/26/03


Date: Sat, 26 Apr 2003 12:51:57 +0300


Dear Andrew,

Thanks for the reply. It helped me a lot. Can you please help me if there is
a way that a DB admin cannot disable certain triggers / procedures. Or is
there a way that we can hide the tables and procedures from the DB admin?

Hope to hear from you soon.

Sincerely

Saleem

"Andrew J. Kelly" <ajkellynospam@attbi.com> wrote in message
news:#a8bMCzCDHA.2172@TK2MSFTNGP12.phx.gbl...
> Please don't post independently in multiple newsgroups. See my reply in
> .programming.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "Muhammad Saleem Usmani" <msusmani@yahoo.com> wrote in message
> news:#K0MC2yCDHA.3008@TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > We have just acquired an application from a vendor which uses SQL
server.
> > The problem is that the vendors have created SQL Server Logins for
every
> > user and have given the passwords to users. Since some of the users have
> > Enterprise Manager installed on their pcs, so they access the DB and at
> > times change the passwords and other things.
> >
> > There are a few things that I want to ask.
> >
> > 1. Is there a way to limit or deny them access through Enterprise
Manager.
> > 2. Is there a way that they cannot manipulate information / passwords.
> > 3. Is there a way that we can hide databases and access information from
> > these users.
> > 4. Is there a mechanism that we can limit certain users to the role of
> > Readers Only.
> >
> > Please note that all the users are grouped in the role public.
> >
> > Any help will be highly appreciated.
> >
> > TIA
> >
> > Saleem
> >
> >
> >
> >
> >
>
>