Re: SQL Server 2005 security question

Harold,

Sure, using SQL Server 2005 Management Studio SP2 and after (and it should
be after, check the recommended patch rollup) this works. If you SQL
desktop tools and server are at a lower level, none of this works properly.

Having said that, Table Properties / Permissions tab should show who has
explicitly granted rights to a table. User or Role / Securables should show
all securables for that user or role. I consider the interface a bit
cumbersome, but it is all there and things can be clicked on or off, objects
added or removed, etc.

RLF

"Harold Shapiro" <HaroldShapiro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D0C6F565-869B-4747-9DD9-9077F3B61D1C@xxxxxxxxxxxxxxxx
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: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)