Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This is more of a theoritical question but I need help ASAP. Here it is:

With the appropriate use of SQL queries, grant as system administrators the required access privileges to a database user named STD01, so he can create a view of a table named CUSTOMER, which belongs to another database user STD00.

Can anyone help me with this?

I know that I have to grant him with the system privilege of CREATE (ANY) VIEW and also give him all the object privileges (SELECT, INSERT, UPDATE & DELETE) on the CUSTOMER table, but I have no idea how can I do that by using SQL...

share|improve this question
Is this some kind of homework? –  FreshPhilOfSO Feb 1 '12 at 18:19
Its a kind of a possible question for an exam I'm having tomorrow, can you help? –  LePhleg Feb 1 '12 at 18:42
add comment

1 Answer

up vote 2 down vote accepted

To grant privilege to create a view:


To grant the DML privileges:


But that's not all of the object privileges. If you did:


you would also give other privileges such as ALTER, INDEX, FLASHBACK, etc.

share|improve this answer
If I grant him only the SELECT privilege, would it still work? –  LePhleg Feb 2 '12 at 0:03
If you just grant select and create view then, yes, it will allow you to create a view on the customer table. –  John Doyle Feb 2 '12 at 0:11
I've just tested this and worked fine, so thats why Im asking. But I guess I'll better write the whole command tomorrow as you did above. You just never know with professors.. Thanks for the help!:) –  LePhleg Feb 2 '12 at 0:17
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.