oraclesql view question

Question

Q. when i create a view on sql browser it show insufficient priviligies,so how i can create a view?

Answer 1

You will need to be granted the CREATE VIEW or CREATE ANY VIEW system privilege on the schema you're working on.

Answer 2

You will also need to have direct SELECT privileges on any tables referenced in your view. SELECT permissions granted via a role will not work. See CREATE VIEW prerequisites.