Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    25

    Unanswered: Privllege on v$instance

    If I want to know the information in the below SQL statement: Select * from v$instance
    are all users can retrieve such information when they give select any table prvillege, or need other prvillege.

  2. #2
    Join Date
    Aug 2002
    Posts
    3

    Cool Re: Privllege on v$instance

    Originally posted by kennypoon
    If I want to know the information in the below SQL statement: Select * from v$instance
    are all users can retrieve such information when they give select any table prvillege, or need other prvillege.
    Hi, you need give select privilege over v_$instance from sys user to any user.

    Regards

Posting Permissions

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