Re: [Gusdev-gusdev] insufficient privileges on Core.Algorithm_SQ sequence

[Juan P. <BI...@ge...>]

> --This is to grant permission to the users
> 
> GRANT CREATE SESSION TO GUSrw;
> GRANT CREATE TABLE TO GUSrw;
> GRANT CREATE VIEW TO GUSrw;
> GRANT CREATE SEQUENCE TO GUSrw;
> GRANT CREATE TRIGGER TO GUSrw;
> GRANT CREATE SYNONYM TO GUSrw;
> GRANT SELECT ANY TABLE TO GUSrw;
> GRANT INSERT ANY TABLE TO GUSrw;
> GRANT UPDATE ANY TABLE TO GUSrw;
> GRANT DELETE ANY TABLE TO GUSrw;
> GRANT CREATE SESSION TO GUSdevReadOnly;
> GRANT SELECT ANY TABLE TO GUSdevReadOnly;
> GRANT SELECT ANY TABLE TO GUSdevReadOnly;
> --------------------------------------------------

To the above list, we had to add the line:

GRANT SELECT ANY SEQUENCE TO GUSrw;

After doing this, the "ga +meta --commit" command worked properly.

Should this have been necessary?  Are other people just making GUSrw into a
DBA or something to get around this?

Thanks,
Juan & Kevin