Oracle Database Discussions

Hi anybody has a script to generate the grants for all database? grants ike this example :



..........ablespace Quotas for CANTOR
ALTER USER CANTOR QUOTA UNLIMITED ON CV_TEMP;
ALTER USER CANTOR QUOTA UNLIMITED ON CV_DATA;
-- 166 Object Privileges for CANTOR
GRANT EXECUTE ON FRSQ.FFFR TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRAVI_INT TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRBOBF2 TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRBOBMPST TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRBOCBCJ TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRBOCN TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRBOTERM TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRDIRBF TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRDIRCBCJ TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRDIRCN TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRDIRTERM TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRLET_INT TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRLST TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRSUBFA TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRSUBFF TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRSUBPFIZ TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRSUBPR TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRSUBRITS TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRSUBTERM TO CANTOR;
GRANT EXECUTE ON FRSQ.FFFRVAL TO CANTOR;
GRANT EXECUTE ON FRSQ.FFUTIL TO CANTOR;
GRANT SELECT ON FRSQ.INFO_DEMANDE TO CANTOR;
GRANT SELECT ON FRSQ.INFO_PROGRAMME TO CANTOR;
GRANT DELETE, INSERT, SELECT, UPDATE ON GDEM.ACCES_DOSSIER TO CANTOR;
GRANT SELECT ON GDEM.ACCES_NON_AUTORISE TO CANTOR;
GRANT EXECUTE ON GDEM.ACCES_UDA TO CANTOR;
GRANT SELECT ON GDEM.AUDIT_ACCES TO CANTOR;
GRANT EXECUTE ON GDEM.COMPOSITION_EQUIPE TO CANTOR;
GRANT EXECUTE ON GDEM.COMPOSITION_EQUIPE_LI TO CANTOR;
GRANT SELECT ON GDEM.COMPOSITION_LI TO CANTOR;
GRANT SELECT, UPDATE ON GDEM.COMPOSITION_SUBV TO CANTOR;
GRANT SELECT, UPDATE ON GDEM.COMPO_TEMP TO CANTOR;
GRANT SELECT ON GDEM.COURRIEL_SEQ TO CANTOR;
GRANT SELECT ON GDEM.DATE_LIMITE TO CANTOR;
GRANT SELECT ON GDEM.DATE_LIMITE TO CANTOR;
GRANT SELECT ON GDEM.DATE_LIMITE_BR TO CANTOR;
GRANT REFERENCES, SELECT ON GDEM.DEMANDE TO CANTOR;
GRANT REFERENCES, SELECT ON GDEM.DEM_LI TO CANTOR;
GRANT SELECT ON GDEM.DOCUMENT_FCAR TO CANTOR;
GRANT EXECUTE ON GDEM.FAFR TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACB3 TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACBO TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACDE TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACDEL TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACDELSC TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACDESC TO CANTOR;
GRANT EXECUTE ON GDEM.FAFRACNP TO CANTOR;

Edited by: Jpmill on Aug 7, 2009 11:05 AM