I am trying to run select query on one of the objects(dba_profiles) in postgres and getting an error as 'SQL: Database error ERROR: permission denied for view dba_profiles' and upon trying to grant permission for the same to my user, it is throwing an error as follows : Command is - sv=> GRANT SELECT ON TABLE dba_profiles TO "MY_USER"; ERROR: permission denied for table dba_profiles
So, is there any other command to grant permission to this table by not getting into superuser mode and staying in normal mode. Or is there any equivalent of it which can directly be used in postgres? Help much appreciated.
Thanks in advance, Rohit