SQL> show user
USER is "SYS"
SQL> grant select on dbo.an_power_files to star;
grant select on dbo.an_power_files to star
*
ERROR at line 1:
ORA-01031: insufficient privileges
USER is "SYS"
SQL> grant select on dbo.an_power_files to star;
grant select on dbo.an_power_files to star
*
ERROR at line 1:
ORA-01031: insufficient privileges
USER is "SYS"
SQL> grant select on dbo.an_power_files to star;
grant select on dbo.an_power_files to star
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> conn system/manager@test
Connected.
SQL> /
grant select on dbo.an_power_files to star
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> conn dbo/***@test
Connected.
SQL> /Grant succeeded.
Connected.SQL> grant select on dbo.an_power_files to system with grant option;
Grant succeeded.SQL> conn system/manager@test
Connected.SQL> grant select on dbo.an_power_files to star;
Grant succeeded.