How to access the Sequence created in other Schema

VTEST · #1 (**permalink**) 02-06-12, 04:06

Hi,

I have created a table with sequence in one schema. I want to access the table from another schema. While i trying to insert new row into that table Oracle giving error message 'ErrorError(61,12): PL/SQL: ORA-02289: sequence does not exist '.

Can you help me to overcome this problem? I am using Oracle 11g.

Thanks in advance....

shammat · #2 (**permalink**) 02-06-12, 04:09

You need to grant the select privilege to that user.

Code:

GRANT SELECT ON your_sequence TO the_other_user

Littlefoot · #3 (**permalink**) 02-06-12, 04:47

Then, you'd reference it using owner's name or, alternatively, create a synonym in your own schema.

Option 1:

Code:

select owner.seq_name.nextval from dual

Option 2:

Code:

create synonym my_seq_name for owner.seq_name;

select my_seq_name.nextval from dual

VTEST · #4 (**permalink**) 02-06-12, 05:34

I have created new synonym and gave Grant access. Now its working fine.

Thank you very much for your reply...

Internet Services

Web Development

Digital Marketing

Consumer Tech