Oracle: Creating view across schemas? Oracle: Creating view across schemas? oracle oracle

Oracle: Creating view across schemas?


oracle view schema

Do you have the grant to the other user's table directly? Or is it via a role? You will need the privilege to be granted directly in order to create an object (view, procedure, etc.) that references the other table. As a quick test, in SQL*Plus

SQL> set role none;SQL> select count(*) from otherschema.othertable;

If that fails, then the problem is that you have been granted privileges on the table via a role.

oracle view schema

I guess you have been given select right on otherschema.othertable via a role not via a direct grant.

If this is the case, you should connect as otheruser and then do a grant select on othertable to <your-schema>.

oracle view schema

I believe that your DBA will need to grant you

create any view

privilege. Depending on the security restrictions at your site they may or not allow this. I typically do not

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last