Sunday, October 18, 2009
How to grant view & 10g
Tried several passwords until I decided to use tiger as my password under user ID system. I opened another SQL session and logged in with ID SYSTEM and used PW tiger and then typed at the sql prompt granted view to user ID Scott;
Friday, October 16, 2009
Permissions
Don't know if anyone else had this problem. While I was doing Week 6 assignment using the Scott account at home, I received a permission error preventing me from completing problem #1. In order to get around this you will have to grant CREATE VIEW permission to the Scott account. To do this, you will need to log in with the SYSTEM login and do the following commands:
GRANT CREATE VIEW
TO scott;
You should then be able to complete problem #1 of the homework.
GRANT CREATE VIEW
TO scott;
You should then be able to complete problem #1 of the homework.
Subscribe to:
Posts (Atom)