I need to find group of users who have a particular role. But i am not able to access SCC_User and SCC_UserGroupRoles tables. When i am running my query, its giving error that i dont have permission to access these tables. I am superuser and i should able to run this query.
I need to find group of users who have a particular role. But i am not able to access SCC_User and SCC_UserGroupRoles tables. When i am running my query, its giving error that i dont have permission to access these tables. I am superuser and i should able to run this query.
There should be no need to access the repository tables directly. There is the "Policy.Simple.xml" if the Workspace was created with just Master and normal user security (the default) and there is "Policy.Aflac.xml" if it has been created with 3-way security (Master, SME and normal user). These files are held in the Workspace folder.
I need to find group of users who have a particular role. But i am not able to access SCC_User and SCC_UserGroupRoles tables. When i am running my query, its giving error that i dont have permission to access these tables. I am superuser and i should able to run this query.
There should be no need to access the repository tables directly. There is the "Policy.Simple.xml" if the Workspace was created with just Master and normal user security (the default) and there is "Policy.Aflac.xml" if it has been created with 3-way security (Master, SME and normal user). These files are held in the Workspace folder.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
