| Author |
Topic |
|
mirza
Starting Member
7 Posts |
 Posted - 2012-06-28 : 08:15:06
|
| I have a database of users and I am creating one more database (lets call it newDatabase). Users are grouped in several groups (group1, group 2, group3...)When I add new item to the newDatabase I should decide which of the users groups needs to see the result of the search. I dont know how to connect these two. I would like someone to help me... |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-06-28 : 08:44:52
|
| from what I understand, you need to Grant privileges to users you are adding to your news database.You didn't really provided much details, but start looking at GRANT commands in SQL server. luck,--------------------------Get rich or die trying-------------------------- |
 |
|
|
mirza
Starting Member
7 Posts |
Posted - 2012-06-29 : 07:52:49
|
| ok i have like this:Document TablePK doc_IDtitletagsbodyfk comiteeComitee tablecomitee_IDname I need to put restrictions to different groups of users who will make queries (executives, finantial affairs, senate, trustees...)The two will have read and write level. Rest must be designed only to read some documents, but not all. When document is created I will make restrictions on who can see the documents |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-29 : 08:00:35
|
| Create nt groups. Map the groups to the server and give it the required access to the database objects.Then you don't have to worry - the windows guys can deal with adding users to the groups.You can handle this in sql server but it means creating the roles and adding users to them on the server.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
mirza
Starting Member
7 Posts |
Posted - 2012-06-29 : 08:05:35
|
| Is it possible to put all the groups to one table and differentiate them by ID? |
|
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-06-29 : 08:31:04
|
quote:
Originally posted by mirza
Is it possible to put all the groups to one table and differentiate them by ID?
If that what you need, you can.But you will be better off creating groups and assigning the desired privileges.--------------------------Get rich or die trying-------------------------- |
|
|
|
mirza
Starting Member
7 Posts |
Posted - 2012-06-29 : 08:50:06
|
| I have more than thousand people and they are divided into groups and i want to give them privilege to see some documents and not to see some documents in query. Problem is I am a newer so I dont know how to implement that. You have given me possible solution but I dont know how to implement it... |
|
|
|
mirza
Starting Member
7 Posts |
Posted - 2012-06-29 : 08:59:20
|
| I see now, problem is every time i add the document on database I will specify the privileges for groups. That means different documents have different permissions to be searched by the group(s) |
|
|
|
|
How to restrict query