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-03 : 16:21:26
|
P. writes "Hi I have recently started on a project where I need to give folder permissions through SQL on SQL Server 7.
The way it works is that there is a folders table and users table, and i need to give permissions where certain users can view only certain folders or contacts and the administrator can view and manage all.
I think that there should be a permissions table that defines the various permission levels that will exist. Then there should be a join table that will be joining the the users with permissions on various folders.
The problem that I am having is that I am not being able to write the appropriate SQL for it. If you can help me with some sample code it would be great.
Regards P." |
|
|
|
|
|
Folder Permissions