Public Sequence Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Public Sequence

  1. #1
    Join Date
    Jun 2004
    Montreal, Quebec, Canada

    Unhappy Public Sequence


    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 ?


  2. #2
    Join Date
    May 2002
    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
    Never give up !

    Nanda Kumar - Vellore

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width