You are viewing limited content. For full access, please sign in.

Question

Privileges and Feature Rights in SQL

Laserfiche Version 9 Integrations

Updated October 21, 2014

asked on October 7, 2014 • Show version history

Where are the Privileges and Feature Rights stored in SQL?

We need to run a third party auditing solution every week to report any changes on trustee security.

0 0

Replies

replied on October 21, 2014

Can someone from Laserfiche share a more helpfull answer?

1 0

replied on October 8, 2014

Hi Bernard,

The privileges and Feature rights are stored in the account_security table in SQL. The privs column stores the privileges and the uif column stores the feature rights. You can convert the decimal value to the binary format and check what privilege or feature right each bit presents.

Hope this would help!

Regards

0 0

replied on October 9, 2014

Thanks for your reply.

Where can I check what each bit means?

Thanks

0 0

replied on October 15, 2014

You may have to add the privileges and feature rights one by one to get what each bit means.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked October 7, 2014
Updated October 21, 2014
371 views