Skip to Content
avatar image
Former Member

Extract privileges by role and users (need sql help)

Hello,

I have to extract all my Privileges in AD (from one folder: one path) in a file, Like

Privilege RoleParent AssignedUser ValidFrom ValidTo

-----------------------------------------------------------------------------------------------

priv1 Role1 User1 Date1 Date2

priv2 Role2 User2 Date2 Date2

priv3 Role3 User3 Date3 Date3

Can you please can you help to privide the optimized sql query? I create a job with to file pass but my need is the sql request.

Thanks,

Vic

Add comment
10|10000 characters needed characters exceeded

  • Hello Victoria,

    you wrote "I have to extract all my Privileges in AD (from one folder: one path)".

    AD = Active Directory? I'm a bit confused.

    And Oracle or SQL database actually makes a difference ("with (nolock)" statement for MSSQL for example), so you should be sure on which you are.

    .

    There are already some questions and blogs (look for Per's) about SQL statements checking various information. You should search a bit for those as this is not a new requirement. ;)

    .

    Regards,

    Steffi.

  • Get RSS Feed

0 Answers