Re: CLIENT PERMISSION
From: Muhammad Saleem Usmani (msusmani_at_yahoo.com)
Date: Sat, 26 Apr 2003 12:51:57 +0300
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.
"Andrew J. Kelly" <email@example.com> wrote in message
> Please don't post independently in multiple newsgroups. See my reply in
> Andrew J. Kelly
> SQL Server MVP
> "Muhammad Saleem Usmani" <firstname.lastname@example.org> wrote in message
> > Hi All,
> > We have just acquired an application from a vendor which uses SQL
> > The problem is that the vendors have created SQL Server Logins for
> > 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
> > 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