![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Frequently Asked Questions |
CREATE PROCEDURE "EffectiveTablePrivileges" (IN "UserName" VARCHAR COLLATE ANSI, IN "TableName" VARCHAR COLLATE ANSI)
BEGIN
DECLARE TempCursor CURSOR WITH RETURN FOR TempStmt;
PREPARE TempStmt FROM 'SELECT TablePrivileges.*
FROM Information.TablePrivileges INNER JOIN
(SELECT Name FROM Configuration.Users WHERE Name=?
UNION ALL
SELECT Name FROM Configuration.UserRoles WHERE GrantedTo=?) Authorizations
ON TablePrivileges.GrantedTo=Authorizations.Name
WHERE TablePrivileges.Name=?';
EXECUTE TempStmt USING UserName, UserName, TableName;
ENDThis web page was last updated on Wednesday, January 5, 2022 at 07:36 AM | Privacy Policy © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? |

