Re: CLIENT PERMISSION

From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 04/26/03

  • Next message: Dejan Sarka: "Re: DATA STRUCTURE VISIBILITY" 
    Date: Sat, 26 Apr 2003 08:39:04 -0400

    If they are sa then they can do anything they want. Do not make someone a
    administrator if you can't trust them to be one. 

    -- 
Andrew J. Kelly
SQL Server MVP
"Muhammad Saleem Usmani" <msusmani@yahoo.com> wrote in message
news:ea19Lm9CDHA.2044@TK2MSFTNGP10.phx.gbl...
> 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
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
  • Next message: Dejan Sarka: "Re: DATA STRUCTURE VISIBILITY"

    Relevant Pages

    • Re: Determine Disk Block Size ?
      ... As always, thanks Andrew. ... Most of the documentation for 2000 is wrong in that it may state you need multiple files to spawn multiple threads. ... >> The MS SQL Server Operations Manual makes a recommendation of using 64-KB>> cluster sizes. ... We have done so with a dramatic total disk I/O>> throughput. ...
      (microsoft.public.sqlserver.server)
    • Re: CLIENT PERMISSION
      ... Dear Andrew, ... there a way that we can hide the tables and procedures from the DB admin? ... > SQL Server MVP ... >> times change the passwords and other things. ...
      (microsoft.public.sqlserver.security)
    • Re: different environment fails to fill a dataset
      ... Well I recreated the login but it didn't make any difference. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
      (microsoft.public.sqlserver.clients)
    • Re: different environment fails to fill a dataset
      ... successfully ran the select command with no problems. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
      (microsoft.public.sqlserver.clients)
    • Re: High availability
      ... I agree with Andrew. ... Senior Database Administrator ... Microsoft SQL Server MVP ... Both scaling up and>>> out ...
      (microsoft.public.sqlserver.clustering)