help wanted with rights

pagecategories

Теги: Cat Rights

MIHDev	#27691 31.12.2010 06:30
Donator Поблагодарили: 1 раз	Hi Ez, Ok, well as far as I know from the tables this query should do it, depends on the levels set as well (possibly). Replace the Auth_GroupID = 1 with the GroupID you wish to view rights for. Replace the Auth_Rights = 1 with >=1 for all rights from Read to Admin. SELECT * FROM Sed_Auth WHERE Auth_GroupID = 1 AND Auth_Code = 'Page' AND Auth_Rights = 1 Use the Auth_Option to filter by page category. SELECT DISTINCT Auth_Option FROM Sed_Auth WHERE Auth_GroupID = 1 AND Auth_Code = 'Page' To filter you could do the following: 1. Get the GroupID of the current user. 2. Use the GroupID of the current user in the SELECT statement above to filter down the Auth_Code and avoid the need for using another select on the Sed_Structure table. Hope this helps. Happy New Year MIHDev [b]Know the question and you will be far more likely to get an answer.[/b]

MIHDev

#27691 31.12.2010 06:30

Hi Ez,

Ok, well as far as I know from the tables this query should do it, depends on the levels set as well (possibly).

Replace the Auth_GroupID = 1 with the GroupID you wish to view rights for.
Replace the Auth_Rights = 1 with >=1 for all rights from Read to Admin.

SELECT * FROM Sed_Auth WHERE Auth_GroupID = 1 AND Auth_Code = 'Page' AND Auth_Rights = 1

Use the Auth_Option to filter by page category.

SELECT DISTINCT Auth_Option FROM Sed_Auth WHERE Auth_GroupID = 1 AND Auth_Code = 'Page'

To filter you could do the following:
1. Get the GroupID of the current user.
2. Use the GroupID of the current user in the SELECT statement above to filter down the Auth_Code and avoid the need for using another select on the Sed_Structure table.

Hope this helps.

Happy New Year

MIHDev

[b]Know the question and you will be far more likely to get an answer.[/b]