Re: Table security
From: David J. Cartwright (davidcartwright_at_hotmail.com)
Date: 09/28/05
- Next message: xxdanbrowne_at_gmail.com: "SSL Encryption Test"
- Previous message: Sue Hoegemeier: "Re: backup and restore a database"
- Next in thread: joseph mallier: "Re: Table security"
- Maybe reply: joseph mallier: "Re: Table security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 28 Sep 2005 15:27:44 -0400
Why make him a user in the other Databases at all ? is guest still enabled ?
Get rid of guest (Default perms)
Create a view with the data you want user to see
give select permission on view
"Radu" <Radu@discussions.microsoft.com> wrote in message
news:6209605F-6B12-4B44-ACF2-B6C4C133A613@microsoft.com...
> Hi guys,
>
> I have a SQL Server 2000 with about 20 databases, each database with few
> hundreds of objects (tables, sps, views etc).
>
> I have a new user (application) who should read data from few columns (not
> all), from only one database, only one table. The rest of 19 databases are
> completely denied. I've created a login for this user and his roles for
> all
> 19 databases are db_denydatareader & db_denydatawrite.
>
> How should I proceed with the last database? Do I need to go on each
> object
> (few hundreds objects) from this database and deny "SELECT", "UPDATE",
> "INSERT" operations, leaving access on only one table? Is there any
> ability
> to put db_denydatareader & db_denydatawrite, excepting table X, allowing
> read-only access on few columns?
>
> Thanks,
> Radu
- Next message: xxdanbrowne_at_gmail.com: "SSL Encryption Test"
- Previous message: Sue Hoegemeier: "Re: backup and restore a database"
- Next in thread: joseph mallier: "Re: Table security"
- Maybe reply: joseph mallier: "Re: Table security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
