user privileges

Hi Denodo team, I am using CATALOG_PERMISSIONS procedure to get user privileges for each userID and each ad group. How can run this procedure to get every userID privileges from every database/ ad group
user
29-08-2018 17:56:30 -0400

1 Answer

Hi, I suspect that you are joining catalog permissions by its inputs to its active directory groups? One way to make sure that you get all of the users on all of the databases, maybe not just ones in the active directory, would be to do a select statement on catalog_permissions(null, null), which will return all of the records for users that have special permissions set, and it already does this across all databases. You could then do a left join to retain those records, joining to your base view over your active directory users by username (as opposed to username_in, which is input for the stored procedure). Users in the database that have special permissions but aren’t in the active directory will produce rows of null values for the columns that come from active directory, and every user in the active directory that exists in VDP will match to their username in the system. Hope this helps!
Denodo Team
30-08-2018 17:14:00 -0400
You must sign in to add an answer. If you do not have an account, you can register here