Re: CLIENT PERMISSION

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

Date: Fri, 25 Apr 2003 09:42:42 -0400

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
>
>
>
>
>

Relevant Pages

  • CLIENT PERMISSION
    ... We have just acquired an application from a vendor which uses SQL server. ... times change the passwords and other things. ... Is there a way that they cannot manipulate information / passwords. ...
    (microsoft.public.sqlserver.security)
  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • Re: Problem: Changing the SQL Server services password - round 2
    ... Tried changing SQL Server 2005 service passwords on a second unrelated ... one node (the node that SSCM was running on), ... As the passwords were set to expire, ... BTW - the command line cluster service password change ...
    (microsoft.public.sqlserver.clustering)
  • RE: New Paper: Microsoft SQL Server Passwords
    ... > Subject: New Paper: Microsoft SQL Server Passwords ... are stored in Microsoft's SQL Server. ... If you select a case-insensitive collation for your SQL Server ... Drop all of the user databases. ...
    (Bugtraq)
  • SQL Server 7 & 2000 Installation process and Service Packs write encoded passwords to a file
    ... Service Packs write encoded passwords to a file. ... When installing Microsoft SQL Server or the latest SQL ... SQL Server login and password used by the installation ...
    (Vuln-Dev)
Quantcast