 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / September 2005Table security
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 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 > Hi guys, > [quoted text clipped - 17 lines] > Thanks, > Radu create a view which contain only the coulmns u want to give access to tht user,and give permission to that view for tht user.Hope this will help u cheers, Joe |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.