Skip to Content
Mar 26, 2017 at 10:22 AM

insufficient privilege: Not authorized while assigning schema to object privilege

254 Views Last edit May 21, 2020 at 03:17 PM 2 rev


In my trial HCP i have created two user usr01 & usr02 and performing below activities:

i) login to trial HCP with SYSTEM user.

ii) assigning schema usr02 to user usr01

iii) while saving im getting below error

404 - Granting privilege 'SELECT' on SCHEMA 'usr02' failed: insufficient privilege: Not authorized

my requirement is to assign object privilege of usr02 schema to user usr01. could anybody please let me know what im missing here.