Solved

Creating A View Is Denied

Posted on 2006-07-18
1
828 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

756 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