Ok I've sorted out that problem.What was doing wrong was trying to set up the privileges with the wrong user.I have four users.And each user has to set the privileges for the next user.
The next hurdle for me is to see if the third user can view the two tables that are connected to the table I've created in this third user.
williamkimber
Last Activity: Feb 28 '11, 05:47 PM
Joined: Dec 16 '10
Location:
-
Unfortunately not!The only way i can log is by using ora1/ora1 or ora2/ora2Leave a comment:
-
yeah that dos'nt workLeave a comment:
-
Infact i'm trying this
But this doesn't work,SQL says that i have insufficient privileges.Code:CREATE USER DEV1 IDENTIFIED BY DEV1
I'm not sure where i'm going wrong?Leave a comment:
-
Ok i think i understand?So you can't create a password for that synonym.
Now I've decided to drop the DEV1 synonym.And now i'm trying to recreate it as a public synonym using the code
This works,and i can see the PUBLICVIEW synonym using select*from tab.But i'm not sure if its public or private because it will not let me use either of those words in the code?Code:CREATE SYNONYM PUBLICVIEW FOR UNIVERSITY;
...Leave a comment:
-
How to create synonym and privileges?
Hello!
I'm trying to create two different users for database using a synonym.Private and public.I've managed to create a synonym using the syntax
I seem to be having some problems creating a pass word for a synonym.Code:CREATE SYNONYM DEV1 FOR UNIVERSITY.EMP;
How would i create a password and create and privileges for two diffrent users?
Any help would be amazing ! Many than... -
I'm trying to remove a column from the structure!Sorry my description was a bit lame!I'm kind of struggling with the syntax of SQL!Leave a comment:
-
How to delete a unwanted university field from my instructor table?
This syntax produces the statement "0 rows deleted"?Code:DELETE FROM INSTRUCTOR TABLE WHERE UNIVERSITY TABLE='INSTRUCTOR';
what am i doing wrong? -
Adding a primary key to a table
Hi i'm having trouble with adding a primary key to a pre created table.
The syntax below is what i'm using to add a primary key to my university table
The error i get is INVALID TABLE COMMANDCode:ALTER TABLE UNIVERSITY ADD CONSTRAINT UNIVERSITY PK PRIMARY KEY(U_PK);
Can anybody help?
Many thanks!!
No activity results to display
Leave a comment: