Skip to main content

grant select on all tables in a schema



GRANT  SELECT on all tables in a schema

Single statement to grant privileges

FOR  x  IN (SELECT * FROM user_tables)
LOOP
 EXECUTE IMMEDIATE  ‘GRANT SELECT ON  ‘ || x.table_name || ‘  TO  << someone >>’ ;
END LOOP;

OR

DECLARE
CURSOR  cur1 IS SELECT TABLE_NAME from user_tables;
cmd varchar2(200);
BEGIN
FOR c in c1 LOOP
cmd := ‘GRANT SELECT ON ‘||c.table_name||<< TO YOURUSERNAME>>’;
execute immediate cmd;
END LOOP;
END;

Popular posts from this blog

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database.

I have submitted this matter in oracle forum but not found any perfect answer.

Do you know why  it's not working ???