Skip to Content
0

Extract privileges by role and users (need sql help)

Apr 19, 2017 at 05:28 AM

35

avatar image

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

10 |10000 characters needed characters left 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.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers