You are here: Re: View Permision sql 2000 « MsSQL Server « IT news, forums, messages
Re: View Permision sql 2000

Posted by Tom Moreau on 01/10/06 23:32

The db_datareader role allows its members to see all views and tables. If
you add tables or views, then they will automatically have SELECT permission
on those objects. If you really want to restrict Joe_Reader, I'd create a
role, grant the appropriate permissions on that role and then add Joe_Reader
to the role.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Juanito" <juan316@sbcglobal.net> wrote in message
news:LKSwf.49486$BZ5.44608@newssvr13.news.prodigy.com...
I created a new user (Joe_Reader) and gave this user the db_datareader Role.
I then went and specified what tables and queries would this user see. This
works fine. I however keep on creating tables and views on the database and
automatically these objects are viewable by the user. I have to manually go
and deny the access for each object I create. Is there a way that I can
only let Jo_Reader see the tables that I originally assigned and that none
of the other queries or views are viewable by him


Thanks

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация