Hello,
I realise that the compilation problems I am having with my sequences, is because they belong to the ALCIE user. They are not public. I cannot create a SYNONYM for a SEQUENCE.
What do you advice ?
How can I make my sequences public ?
PT
Printable View
Hello,
I realise that the compilation problems I am having with my sequences, is because they belong to the ALCIE user. They are not public. I cannot create a SYNONYM for a SEQUENCE.
What do you advice ?
How can I make my sequences public ?
PT
Not enough information !
You mean you don't have privileges to create synonym?
Either get privileges to CREATE SYNONYM for the sequence and ask ALCIE to GRANT SELECT privilege on the sequence.
Or Check if ALCIE has CREATE ANY SYNONYM privilege, if so ask ALCIE to create synonym for the sequence in your schema and also to grant you select privilege on the sequence.
- Nandu