Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio 15.0.0-dev-314
Build #: 38339
Built on: 2014-Jun-06 05:37:08 PM
Steps to Reproduce.
1.Connect to Oracle12c
2. Create the below synonym :
We can rename Oracle Synonyms - see attached screenshot.
@tariq: When we create synonym in user defined schema,we are not able to edit anything,we are not able to rename also,when we create synonym for system based schema we are able to alter synonym.
As per documentation to modify a private synonym in another user's schema, you must have the CREATE ANY SYNONYM and DROP ANY SYNONYM system privileges.
I have given both create any synonym, drop any synonym system privileges to schema "c##project" but still I am not able to modify the synonym .
@tariq: When we create synonym in user defined schema,we are not able to edit anything,we are not able to rename also,when we create synonym for system based schema we are able to alter synonym.
As per documentation to modify a private synonym in another user's schema, you must have the CREATE ANY SYNONYM and DROP ANY SYNONYM system privileges.
I have given both create any synonym, drop any synonym system privileges to schema "c##project" but still I am not able to modify the synonym .
Issue #12270 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
We can rename Oracle Synonyms - see attached screenshot.