grant on view

Database

grant on view

Hi All,

I have a view abc.acd and i am granting select access to XYZ user

Grant select on abc.acd to xyz;

but when selecting the view through XYZ user its giving result zero rows and selected through the DBA its giving results

Note :- XYZ having default role as all

Please help me on this 

Thanks in advance

Regards,

Praveen

Tags (1)
1 REPLY

Re: grant on view

I have a view abc.acd and i am granting select access to role role_1

Grant select on abc.acd to role1;

XYZ,LMN is the user in role1

but when selecting the view through XYZ,LMN user's its giving result zero rows and selected through the DBA its giving results

Note :- XYZ,LMN having default role as all

Please help me on this 

Thanks in advance