Timeline for Oracle Schema Privileges Other Users
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2017 at 10:42 | vote | accept | rodrigortz | ||
| Mar 7, 2017 at 10:40 | comment | added | atokpas |
Yes, SELECT ANY TABLE can let you create views by selecting any of the tables belong to user1.
|
|
| Mar 7, 2017 at 10:35 | comment | added | rodrigortz |
So if I would just want to create views, materialized views and procedures in my *own* schema based on other users tables, would I just require the SELECT ANY TABLE privilege? I see it from the standpoint that the CREATE VIEW command is really just pulling data from other tables (for which I need permission) but creating the view in my schema, not user1's schema, correct?
|
|
| Mar 7, 2017 at 10:28 | comment | added | atokpas |
If you grant SELECT ANY TABLE to a user, he/she can select all the tables of that particular schema. And CREATE ANY PROCEDURE system privilege permits a user to create a procedure anywhere in the database. So it depends upon your requirements.
|
|
| Mar 7, 2017 at 10:22 | comment | added | rodrigortz |
Would it be better to grant the ANY privileges to user2 (SELECT ANY TABLE, CREATE ANY PROCEDURE, etc)?
|
|
| Mar 7, 2017 at 5:28 | history | edited | atokpas | CC BY-SA 3.0 |
deleted 12 characters in body
|
| Mar 7, 2017 at 4:48 | history | edited | atokpas | CC BY-SA 3.0 |
added 31 characters in body
|
| Mar 7, 2017 at 4:30 | history | edited | atokpas | CC BY-SA 3.0 |
added 7 characters in body
|
| Mar 7, 2017 at 3:33 | history | answered | atokpas | CC BY-SA 3.0 |