Re: Securing tables

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/20/04

Next message: Steve B.: "Passing a variable column name to a stored procedure"
Previous message: jaylou: "Securing tables"
In reply to: jaylou: "Securing tables"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 20 Dec 2004 12:02:47 -0500

The best way to do this is thru the use of roles and only assigning the
proper permissions to the appropriate roles to do what you want.

-- 
Andrew J. Kelly  SQL MVP
"jaylou" <jaylou@discussions.microsoft.com> wrote in message 
news:CCAED49C-5B56-47AF-B9BD-F5C19A4A368D@microsoft.com...
> Hi All,
> I have a few tables in my database that I would like to make read only for
> all user except one.  Is there a way to do this?
>
> TIA,
> Joe
>

Next message: Steve B.: "Passing a variable column name to a stored procedure"
Previous message: jaylou: "Securing tables"
In reply to: jaylou: "Securing tables"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]