security permissions of roles\users on table rows

From: Panagiotis Konstantinidis (panagiotis@melonweb.gr)
Date: 07/05/02 

From: "Panagiotis Konstantinidis" <panagiotis@melonweb.gr>
Date: Fri, 5 Jul 2002 13:05:39 +0300

We want to be able to grant permissions to roles and\or users on table rows
(not on columns). For example, when user A selects all rows, only those rows
should be returned that user A has been granted permission to see. User A
may have another set of rows from the same table, that user A will be able
to update, another set for deletion, etc.

However, some of the rows of the above mentioned table will be able to be
selected by other users as well, according to each user's individual
permissions on each row.

Can the above mentioned system be implemented with the help of the built-in
role\user system of SQL2K and how? I know that permissions may be assigned
to roles and users with respect to tables and tabvle columns. But what
happens with table rows?

If the built-in permissions system canot be employed, any ideas about how to
do it, i.e. have groups and users with individual permissions on table rows
(like the NTFS file system)?

Thanks in advance for any replies.

Regards,
Panagiotis

Relevant Pages

  • Re: Question on Special Permissions
    ... Permissions are just groups of special permissions so you don't have to tick lots of individual permissions. ... > I do not want to move the individual Users to Power Users Group since I only ...
    (microsoft.public.windowsxp.general)
  • Re: security permissions of rolesusers on table rows
    ... > We want to be able to grant permissions to roles and\or users on table ... > Can the above mentioned system be implemented with the help of the ... > If the built-in permissions system canot be employed, ... i.e. have groups and users with individual permissions on table ...
    (microsoft.public.sqlserver.security)
  • Re: security permissions of rolesusers on table rows
    ... > - click permissions button ... >> If the built-in permissions system canot be employed, ... i.e. have groups and users with individual permissions on table ... >> Regards, ...
    (microsoft.public.sqlserver.security)
  • Specific User Permissions
    ... Hi Craig, ... you wish to get all the permissions on the Product table ... database in Query Analyzer ...
    (microsoft.public.sqlserver.security)