| Author |
Need help in setting up row level security ...
|
|
|
| I would like to implement row level security. Can someone help me please?
I have a situation wherein a Project is created as confidential. Only a few
people should be able to access it. I have this information in another table
called
ProjectEmp and OverrideProjects. these two tables contain userid information
of users who may access the project.
How can I implement the row level security?
Table Project - Fields are -
ProjectNo
ProjectDesc ....
ConfidentialityFlag = 'Y/N'
Table ProjectEmp - Fields are -
ProjectNo + EmpCode (Key)
Table OverrideProject - Fields
ProjectNo + EmpCode (Key)
-----------
The reason Emp reference is kept in two tables is because ProjectEmp is
applicable for all projects whereas OverrideProject is applicable to only
Confidential projects.
So that all those associated with the Project can access it and others
depending on need will be allowed and can be removed sometimes.
Thank you in advance,
-Me
| |
| Arnie Rowland 2006-10-24, 6:28 pm |
| Perhaps these will help:
Security -Best Practices
http://vyaskn.tripod.com/ sql_serve...t_practices.htm
Security -Giving Permissions through Stored Procedures
http://www.sommarskog.se/grantperm.html
Security -Row Level
http://vyaskn.tripod.com/ row_level...as
es.htm
http://blogs.msdn.com/federaldev/ar.../13/550585.aspx
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Me" <Me@discussions.microsoft.com> wrote in message
news:19020BBB-0EBF-45A7-B4B3- 0DAB6D48D32E@microso
ft.com...
>I would like to implement row level security. Can someone help me please?
> I have a situation wherein a Project is created as confidential. Only a
> few
> people should be able to access it. I have this information in another
> table
> called
> ProjectEmp and OverrideProjects. these two tables contain userid
> information
> of users who may access the project.
>
> How can I implement the row level security?
>
> Table Project - Fields are -
> ProjectNo
> ProjectDesc ....
> ConfidentialityFlag = 'Y/N'
>
> Table ProjectEmp - Fields are -
> ProjectNo + EmpCode (Key)
>
> Table OverrideProject - Fields
> ProjectNo + EmpCode (Key)
>
> -----------
> The reason Emp reference is kept in two tables is because ProjectEmp is
> applicable for all projects whereas OverrideProject is applicable to only
> Confidential projects.
> So that all those associated with the Project can access it and others
> depending on need will be allowed and can be removed sometimes.
>
> Thank you in advance,
> -Me
>
| |
|
|
|
|
|
|
|
|