Permission settings on database
I wanted to see on our SQL database where Quality Center saved the entry for "Customize Project Lists".
This value has to be set in the customization - groups - change - administration(tab)
I tried to find the value in the "ac_grant_mask" column of the "actions" table on our database.
But it looks like it isn't there.
Has anyone an idea where Quality Center saves this value?
Re: Permission settings on database
It is saved in the TB_GRANT_MODIFY column of the TABLES table, where TB_TABLE_NAME = "ALL_LISTS".
Here is some OTA code to access to that value :
<font class="small">Code:</font><hr /><pre>
Function fnUserAllowed2(EntityName As String) ' As Boolean
Dim cust 'As TDAPIOLELib.Customization
Dim userGroupsList 'As TDAPIOLELib.List
Dim group 'As TDAPIOLELib.CustomizationUsersGroup
Dim permissions 'As TDAPIOLELib.CustomizationPermissions
Dim i 'As Long
Dim b 'As Boolean
b = False
On Error Resule Next
Set cust = TDConnection.Customization
Set userGroupsList = cust.Users.User(TDConnection.UserName).GroupsList( )
Set permissions = cust.permissions
For i = 1 to userGroupsList.Count
Set group = userGroupsList.Item(i)
b = b Or permissions.CanModifyItem(EntityName, group.Name)
fnUserAllowed2 = b
Set permissions = Nothing
Set userGroupsList = Nothing
Set cust = Nothing
userCanModifyLists = fnUserAllowed2 ("ALL_LISTS")
This code is available on TDForums