Comments

• Don_1

  May 2014

  Help me on this please.

  0
• Adrian_Oprea_1

  May 2014

  If you drop that object in that period of time the grant will be lost !! 
  See example : 
  
  

  dbadmin=> grant select on rio_desc to test1;  GRANT PRIVILEGE  
  dbadmin=> SELECT grantee, grantor, privileges_description, object_schema, object_name
  dbadmin->    FROM grants WHERE grantee='test1';
   grantee | grantor | privileges_description | object_schema | object_name
  ---------+---------+------------------------+---------------+-------------
   test1   | dbadmin | USAGE                  |               | general
   test1   | dbadmin | SELECT                 | public        | rio_desc
  (2 rows)    -- see grants given 
  dbadmin=> SELECT grantee, grantor, privileges_description, object_schema, object_name
  dbadmin->    FROM grants WHERE grantee='test1' and object_name='rio_desc' ;
   grantee | grantor | privileges_description | object_schema | object_name
  ---------+---------+------------------------+---------------+-------------
   test1   | dbadmin | SELECT                 | public        | rio_desc
  (1 row)    -- drop object
  dbadmin=> drop view rio_desc ;
  DROP VIEW
  dbadmin=> SELECT grantee, grantor, privileges_description, object_schema, object_name
  dbadmin->    FROM grants WHERE grantee='test1' and object_name='rio_desc' ;
   grantee | grantor | privileges_description | object_schema | object_name
  ---------+---------+------------------------+---------------+-------------
  (0 rows)    -- no role left  
  dbadmin=> create view rio_desc as select * from rio;
  CREATE VIEW
  dbadmin=> SELECT grantee, grantor, privileges_description, object_schema, object_name
  dbadmin->    FROM grants WHERE grantee='test1' and object_name='rio_desc' ;
   grantee | grantor | privileges_description | object_schema | object_name
  ---------+---------+------------------------+---------------+-------------
  (0 rows)

  -- still no role even after you recreate the object.
  
  

  0