RE: Roles based security 2005 versus 2000

Hi Peter,
Thank you.
In my opinion, the best way to handle data overload could be to add a filter by... ability as standard in the Oracle SQL Developer here http://www.oracle.com/technology/products/database/sql_developer/index.html ..

Cheers,
Francisco

Hello Francisco,

I was able to repro the problem as following:

1. In SQL Mgmt Studio expand SECURITY under a specific Database and
then
Expand ROLES
2. RIght-Click on "DATABASE ROLES" and select "Create Database Role"
3. Specify the Name of the Role and click OK
4. Right-Click on the Database Role and select Properties
5. In the Properties Dialog select the SECURABLES page
6. Add a Table Object as a securable and specify some "Specific
Permissions"
7. Click on OK to save and close
8. Look at the Properties of the Database Role again and select the
SECURABLES page
9. Note that the Securable Object added does not show up in here
10. If you add the same object back in again it retains the previous
settings
This is a known issue and has been reported to the product group. From
the
feedback of product team, this behavior is by design due to the
following
reason:
there could conceivably be hundreds of thousands of objects in a
database.
Attempting to display all the objects and permissiosn would be time
consuming. Product team remove this feature to optimize the
performance of
Management studio. By searching for a particular tables/SPS again,
you
will see the active permission settings. The permissions you added are
active and if you try to grant the permissions again by select the
tables/sps, you shall see the permissions you added.
Also if you want to display the all the permssions of a database role
from your own application, you may consider use databaserole object
in SMO to do this job. You may use EnumObjectPermissions method to get
all the permissions.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.managemen
t.smo. databaserole.enumobjectpermissions.aspx

Please rest assured that your feedback on this is routed to the
product team. There might be a feature to allow users to
enable/disable this feature if they want to see the list and having no
concerns about performance. In the meantime, I also encourage you
submit via the link below

http://lab.msdn.microsoft.com/productfeedback/default.aspx

Please let's know if you have any further concerns on this issue.
Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================

This posting is provided "AS IS" with no warranties, and confers no
rights. ======================================================




.

Relevant Pages

  • RE: Roles based security 2005 versus 2000
    ... Right-Click on the Database Role and select Properties ... In the Properties Dialog select the SECURABLES page ... Add a Table Object as a securable and specify some "Specific Permissions" ... feedback of product team, this behavior is by design due to the following ...
    (microsoft.public.sqlserver.security)
  • Re: Why securities disappear in SQL Server 2005 ?
    ... Do you consider that an enhancement to a 5 years old tool - Enterprise ... objects and it should show you permissions that you have already given on ... database role then from role securities tab i assign permissions to ... securities to users then everything is ok, ...
    (microsoft.public.sqlserver.security)
  • RE: how to deal with public role?
    ... All databases contain a public database role of which all users, ... roles are members. ... Do not grant additional permissions to this role. ...
    (microsoft.public.sqlserver.security)
  • Re: Why securities disappear in SQL Server 2005 ?
    ... objects and it should show you permissions that you have already given on ... I'm using SQL Server 2005 and MS Management Studio, ... database role then from role securities tab i assign permissions to ... securities to users then everything is ok, ...
    (microsoft.public.sqlserver.security)
  • Re: Viewing Role Permissions for Custom Role
    ... permissions I granted to that role. ... area, but I just ran a test in SP2: I took a role, went to the Securables ... the objects I had granted rights to appeared. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
Loading