sqloraclevieworacle-sqldeveloper
How to set the right to see a view in oracle?
I am logged in as user "a" in my oracle database.
I can write a query like "Select * from MyView" and I get all results - thats fine.
BUT I can't see the view itself in SqlDeveloper in my View-tree (list), additional to that I am not the owner (which I can see with "Select * from all_views").
How can I change the rights of this view to see "MyVIew" in the tree?
Solution
@Littlefoot is correct in his answer. You could of course also browse to the view directly via the 'Other Users' portion of the tree, then drill down into the Views.
BUT, you could also just set your Views filter to 'Include Synonyms'
I wrote a story on this topic for TABLES, but it also applies to VIEWS here.
- How to select rows with no matching entry in another table?
- Get count of id for each day and Group by date
- How can I replace a string in a MySQL database for all tables in all fields in all rows?
- Date set in parameter does not match with date when querying the parameter
- Getting error recursive reference to query must not appear within its non-recursive term in postgres
- sqlcmd how to run a query against specific database?
- SQL query engine for text files on Linux?
- Postgres split time ranges into 1 minute slots, without rounding boundaries
- Time and Attendance query, First transaction of the day per person
- How do you execute SQL from within a bash script?
- How to write this SQL query to find each account balance?
- How do I speed up querying my >600Mio rows?
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- Why is "connection.queries" returning an empty list in Django?
- Extracting value from comma-delimited string in Teradata
- How to sort all numbers before letters with linguistic sorting?
- How to add multiple columns in AWS redshift with alter table query
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL query left join with sum,group by and order by in MS Access
- Update an existing sql table based on content from an external csv file?
- SQL Formatting a string (name)
- Oracle Sql Statement for unique timestamp for each row
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How do I suppress T-SQL warnings when running a script SQL Server 2005?
- How can I group time by hour or by 10 minutes?
- SQL syntax error when trying to create a new table using TypeORM
- How to use PERCENTILE_CONT without over clause? any alternative to it?
- Success message for an end user inside an SQL procedure
- Does Oracle field contain all letters from a string?