cancel
Showing results for 
Search instead for 
Did you mean: 

permission to view content of table of SYS schema to newly created user

phaniram_vulisi
Explorer
0 Kudos

Hi,

I am facing issue giving permission to view contents of table p_users of SYS schema to newly created user.

Regards,

Phani Ram

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Phani,

your question was already answered here:

In short, do not access table SYS.P_USERS_ but the view USERS which shows you the exact same data.

Regards,

Mark

Former Member
0 Kudos

Hi Phani,

Could you please check if you have an a authorization to give a permission to other users for particular schema.

I mean check for privileges, user and roles.


Warm Regards,

Earesh kumar