Posted by Juanito on 01/10/06 20:08

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

• Next in forum: bcp into view with derived column
• Prev in forum: Preventing the message 'Duplicate key was ignored'
• Thread view: View Permision sql 2000

[Reply to this message]