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;

Password for System

What is the password for system ID?

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.