![]() | ![]() 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; END
This 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 ? ![]() |