Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-01 : 11:02:40
|
Nikki writes "Hi Guys,
I'm writing an application that needs to implement row-level security much like Windows NT file security. E.g. Permissions can be inherited just as a user can be explicitly denied access to a file.
I have 1 table holding permissions and 6 tables that all have a unique id and parent id for each row but contain very different data so they must be separate tables.
The permissions table contains the users SID, TableId, RowId and permission flags (GRANT, INHERIT, [ALLOW|DENY] READ WRITE CREATE_CHILD DELETE DELETE_CHILD)).
The 6 tables are related as such:
Table1
Table2
Table3
Table4
Table5
Table6
I've tried cascading triggers and stored procedures but still no luck.
I now have a mushy brain thanks to this problem so I hope you can help out!
BTW I'm using Windows 2000 SP1 and SQL Server 7 SP3" |
|
|
|
|
|
Row-level security for a database application