Hi all,
I have create a temporary user with public db role and give him select
permission on one view, this is perfect for user defined objects scenario,
that the user can not access any user defined objects but the issue is here
that the user can access system objects and system db’s objects which is
critical for me. Is there any why to restrict that particular user for access
that system objects and db’s….
Waiting for your reply anxiously
Farhan Iqabl
Mike Epprecht (SQL MVP) - 08 Aug 2005 17:17 GMT
Hi
The system DB's and system objects access is required. You can't turn that
off.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
> Hi all,
> I have create a temporary user with public db role and give him select
[quoted text clipped - 8 lines]
> Waiting for your reply anxiously
> Farhan Iqabl