how to give grant on gv$parameter to a user
Hello,
How am i suppose to give a user access to view gv$parameter and gv$instance to a user. I am trying to grant select on sys.gv$parameter to user;
also tried grant select on gv$parameter to user;
and its not working. Is there a role that can be given. This need to be done, so that the user can monitor the performance. how would i go about doing this. THank