No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How to Query the System ACL and the User ACL by Running the Database Command

Publication Date:  2012-07-24 Views:  52 Downloads:  0
Issue Description
Q:
When the user at the client cannot log in normally because of the ACL, in order to locate the problem, we need to know whether the ACL information displayed at the client is actually written to the database. Then, How to Query the System ACL and the User ACL by Running the Database Command? 
Alarm Information
Null
Handling Process
A:
Log in to the database with isql, and run the following commands to query the system ACL in the database. 
1>use SecurityDB
2>go
1>select * from tbl_SysAcl
2>go
Run the following commands to query the user ACL information in the database.
1>select * from tbl_UserAcl
2>go
Root Cause
Null
Suggestions
Null

END