Difference between revisions of "Grantee"

From wikieduonline
Jump to navigation Jump to search
(Created page with " SELECT grantee, privilege_type FROM information_schema.role_table_grants WHERE table_schema = 'your_table_schema' AND table_name = 'your_table';")
 
 
Line 1: Line 1:
  
  
  SELECT grantee, privilege_type  
+
  [[SELECT]] [[grantee]], [[privilege_type]]
  FROM information_schema.role_table_grants  
+
  FROM [[information_schema]].[[role_table_grants]]
 
  WHERE table_schema = 'your_table_schema'  
 
  WHERE table_schema = 'your_table_schema'  
 
  AND table_name = 'your_table';
 
  AND table_name = 'your_table';

Latest revision as of 10:21, 4 November 2024


SELECT grantee, privilege_type 
FROM information_schema.role_table_grants 
WHERE table_schema = 'your_table_schema' 
AND table_name = 'your_table';

Advertising: