CODEWITHSUNDEEP
oracle-databaseoracle9i
manish
manish

Reputation: 21

oraclesql view question

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

Upvotes: 1

Views: 61

Answers (2)

DCookie
DCookie

Reputation: 43523

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.

Upvotes: 3

CodingGorilla
CodingGorilla

Reputation: 19842

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

Upvotes: 3

Related Questions