Re: SQL Server 2005 security question

Thank you for the tip. Is there anyway to graphically display this
information so the dbo can add or take away rights to table, view, setc?


"Russell Fields" wrote:

Harold,

In the database in question, have him run sp_helprotect.

RLF

"Harold Shapiro" <HaroldShapiro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BB0B6EE3-4873-4314-B33F-5E34BD549B4F@xxxxxxxxxxxxxxxx
What he wants to do is be able to view the table by table permssions for
users or roles without going through each table in the database.

"Harold Shapiro" wrote:

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?





.

Relevant Pages

  • Re: securityadmin
    ... add the database user to db_datareader, ... fixed server role Security Administrators. ... I can go ahead and add that login as a database user and add them ...
    (microsoft.public.sqlserver.security)
  • EJB3.0 Entities and database password control
    ... impressed by the apparent simplicity that the use of entity beans ... the backend database. ... Rather than a single database user, I want to have one of the ... connection between my entities and the database happens as if by ...
    (comp.lang.java.databases)
  • Re: SQL Users (Basic Question)?
    ... A login is stored in the master database. ... ability to connect to the SQL Server. ... A database user allows a login to use a particular database and the entry is ...
    (microsoft.public.sqlserver.security)
  • RE: Question from Assessment
    ... Database User, Database Role, and Application Role. ... then the answer would be a Database User and/or and Application Role. ... You are the senior database administrator for a personnel management ... The company recently upgraded all servers running SQL Server 2000 to SQL ...
    (microsoft.public.sqlserver.security)
  • Re: SecurityAdmin server role
    ... Add that login to that partcular database as a database user and assign ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)