Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Other SQL Server Topics / August 2005

Tip: Looking for answers? Try searching our database.

Security issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Farhan - 08 Aug 2005 11:12 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.