Nakuru1234
asked on
Create Oracle Synonym
Hello,
I have created a table name UTGWEBRESULTS in the UTG Schema. Now, I need to create a synonym in UTGUSER. How can I execute it? Here is my create sql statement;
CREATE TABLE UTG.UTGWEBRESULTS
(
"Request ID" CHAR(64),
Results CLOB
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
ALTER TABLE UTG.UTGWEBRESULTS ADD (
CONSTRAINT UTGWEBRESULTS_PK
PRIMARY KEY
("Request ID"));
TIA,
N.
I have created a table name UTGWEBRESULTS in the UTG Schema. Now, I need to create a synonym in UTGUSER. How can I execute it? Here is my create sql statement;
CREATE TABLE UTG.UTGWEBRESULTS
(
"Request ID" CHAR(64),
Results CLOB
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
ALTER TABLE UTG.UTGWEBRESULTS ADD (
CONSTRAINT UTGWEBRESULTS_PK
PRIMARY KEY
("Request ID"));
TIA,
N.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had to log into UTGUSER and create it with that account because I could not as UTG. But now I need to apply a GRANT back to UTG from UTGUSER table I created. How can I do that?
Tia,
N.
Tia,
N.
You need to grant specific privs on the base table as the table owner. This was mentioned in http:#a37778524
ASKER
ASKER
I am doing GRANT select, update, delete on UTG.UTGWEBRESULTS. Is that correct?
TIA,
N.
TIA,
N.
It is a reference link to post 37778524 in this question.
works for me.
works for me.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, its not Prod. So, I can give them those permissions. Thank you for asking.
TIA,
N.
TIA,
N.
ASKER
Tia,
N.