Solved

Creating A View Is Denied

Posted on 2006-07-18
1
824 Views
Last Modified: 2008-03-03
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
Comment
Question by:Mahonek
1 Comment
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 75 total points
ID: 17136639
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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now