Re: Setting Up SQL Security

Hi
Create a view to access the data and grant SELECT permission to the user.
Deny access on underlying tables
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --------security
best practices











"dsfseattle" <dsfseattle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51E2AE5F-15E7-4097-AFC4-56227D9E81D6@xxxxxxxxxxxxxxxx
I have setup in sql server via Enterprise Manager a user. I pretty much
want
that user to have complete access to a database. The application is
Darwin.
What I would like to do is limit the companies that this user would
access.
For example, company 1 would be off limits, whereas company 2 through 5
would
be available. Any direction would be appreciated.


.

Relevant Pages

  • Re: Deny access to copy files
    ... On Mon, Jun 23, 2008 at 11:41 PM, Michael P. Carter ... Deny access to copy files ... Not so - any user denied permission to COPY will inherently be denied ...
    (Security-Basics)
  • Re: Deny access to copy files
    ... On Tue, Jun 24, 2008 at 9:54 PM, Michael P. Carter ... Deny access to copy files ... Not so - any user denied permission to COPY will inherently be denied ...
    (Security-Basics)
  • Re: Deny access to copy files
    ... opens a file and reads data into a buffer its free to write that ... Not so - any user denied permission to COPY will inherently be denied ... Deny access to copy files ... Technitium Personal Computers ...
    (Security-Basics)
  • Re: Election outcome
    ... Well, any sexual act without the permission of the woman constitutes rape, ... practices between those with different sexual orientations but, as usual, ... > I don't want you to think I'm being short with you, Janice, but this ...
    (sci.med.transcription)
  • RE: Deny access to copy files
    ... the NTFS permission READ will allow anyone with that permission to ... Deny access to copy files ... "Read + Execute" I guess this could do the work but is there any other ...
    (Security-Basics)