Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

Creating A View Is Denied

Hello, Can someone help me understand how to resolve the below error message that I got while trying to Creating A View?  

Server: Msg 262, Level 14, State 1, Procedure vw_AllActiveStaff, Line 8
CREATE VIEW permission denied, database 'PROD', owner 'dbo'.

Thanks.
Mahonek
0
Mahonek
Asked:
Mahonek
1 Solution
 
nmcdermaidCommented:
From books online:



CREATE VIEW permission defaults to the members of the db_owner and db_ddladmin fixed database roles


If you aren't in one of those roles:

To create a view, the user must have CREATE VIEW permission along with SELECT permission on the tables, views, and table-valued functions being referenced in the view......


So whatever user you are logging in is no a member of db_owner or db_ddladmin, and does not have CREATE VIEW permission.

So go into Enterprise Manager and check your users role membership and rights.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now