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

[Back to original message]