DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Public Sequence

  1. #1
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy Public Sequence

    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

  2. #2
    Join Date
    May 2002
    Posts
    108
    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