Re: SQL Server 2005 security question
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 25 Jan 2008 15:03:03 -0800
Harold Shapiro (Harold Shapiro@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I am new to SQL Server 2005. I have a user who is db_owner equivalent.
However, when he starts SQL Server Management Studio (logged in with his
ID), he cannot see anyting in the Securables box under database user
properties or database role properties. Is there anyway to have him see
this information?
IF I understand this correctly, your user want to be able to look at the
user PlainVanilla, to see which securables PlainVanilla has access to.
Is that so?
Which version of Mgmt Studio do you have? It sounds like you have the RTM
version or SP1. This was addressed in SP2. You can check the version of
Mgmt Studio under Help About. It should say 9.00.3042 or higher.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: SQL Stored procedure access?
- Next by Date: Re: Can't login to SQL Server
- Previous by thread: Re: SQL Server 2005 security question
- Next by thread: Security - Lock Database
- Index(es):
Relevant Pages
|
