Limiting objects displayed in QA Object Browser
-
Is there a way to limit the database objects displayed in a user's Query Analyzer Object Browser to the objects to which the user has permission? By default, users seem to be able to see everything. Thanks, Paul
-
If he has any permission on any object he will see it because he will be in public role of DB. The next thing is what is granted to him
-
The user is granted select on a small subset of views in one database. The problem is that he can see all the other views (plus all tables) in Query Analyzer Object Browser, a confusing assortment for him. He cannot do anything with most of the objects he can see. I would like him to see in Object Browser only the views from which he can select. Is there any way to do that? Thanks, Paul
-
Unfortunatley Query Analyzer Object Browser uses sysobjects directly.
The only way would be to rename sysobjects, create a view that uses sysobjects and filter by user permissions and of course the name would be sysobjects. But I am sure you are not going to do that, do you?
* Noel -
Too bad. I don't think I want to mess with system tables or views. Thanks, Paul
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply