Question:
How can I check the owner permissions for my file cabinets?
Answer:
The following queries can be run against your databases. They will return the name of the file cabinet and the associated users who currently have owner permissions.
MySQL
USE DWSYSTEM;
SELECT DWFileCabinet. fid, DWFileCabinet. name as 'File Cabinet', DWFCProfileToUser. uid, DWUser. name as 'User
Name '
FROM DWFileCabinet, DWFCProfile, DWFCProfileToUser, DWUser
WHERE DWFileCabinet. fid = DWFCProfile. fid
AND DWFCProfile. fpid = DWFCProfileToUser. fpid
AND DWFCProfile. name = 'Owner'
AND DWFCProfileToUser. uid = DWUser.uid
MSSQL
USE DWSYSTEM;
GO
SELECT DWFileCabinet. fid, DWFileCabinet.name as 'File Cabinet', DWFCProfileToUser. uid, DWUser. name as 'User
Name '
FROM DWFileCabinet, DWFCProfile, DWFCProfileToUser, DWUser
WHERE DWFileCabinet. fid = DWFCProfile.fid
AND DWFCProfile. fpid = DWFCProfileToUser. fpid
AND DWFCProfile. name = 'Owner'
AND DWFCProfileToUser.uid = DWUser.uid
In this example, admin and George are both assigned to the admin profile of the First cabinet, while the second cabinet only has admin assigned to the owner profile, and the third cabinet only has George assigned.
KBA is applicable to On-Premise Organizations ONLY.