zephyr_hex (Megan)
asked on
SELECT denied in AdventureWorksDW - SQL Server 2005
i am trying to work through an Analysis Services tutorial for SQL Server 2005. everything has been peachy until i get to the point where i'm supposed to deploy my AdentureWorksDW cube.
when i attempt to deploy, i get the following error:
Error 3 OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object 'DimProduct', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
i have checked and i have a log in (my domain account) with roles "public" and "sysadmin", and i'm listed as a user under AdventureWorksDW->Security ->Users with default schema dbo.
i checked schemas->dbo, and i see nothing explicitly listed. is this the problem? when i look through the other schemas in other databases, i see nothing explicitly granted...
when i look under AdventureWorksDW->Security ->Roles, i don't see sysadmin listed... public is there... as are the other roles like db_datareader. is this correct?
i also noticed when i look at the schemas owned by me in AdventureWorksDW->Security ->users that nothing is checkmarked.... and db_denydatareader is listed... are items enabled when checkmarked? do i need to checkmark the non-deny items?
so, basically, i am a bit confused about what needs to be in place in order to fix this error... what do i need to verify?
sql server 2005 enterprise
thanks.
when i attempt to deploy, i get the following error:
Error 3 OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object 'DimProduct', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
i have checked and i have a log in (my domain account) with roles "public" and "sysadmin", and i'm listed as a user under AdventureWorksDW->Security
i checked schemas->dbo, and i see nothing explicitly listed. is this the problem? when i look through the other schemas in other databases, i see nothing explicitly granted...
when i look under AdventureWorksDW->Security
i also noticed when i look at the schemas owned by me in AdventureWorksDW->Security
so, basically, i am a bit confused about what needs to be in place in order to fix this error... what do i need to verify?
sql server 2005 enterprise
thanks.
are items enabled when checkmarked? Yes
i see nothing explicitly granted...
when i look under AdventureWorksDW->Security ->Roles, i don't see sysadmin listed... public is there... as are the other roles like db_datareader. is this correct? Yes.
I dont know if you know but this tells all
http://msdn2.microsoft.com/en-us/library/ms189121.aspx
i see nothing explicitly granted...
when i look under AdventureWorksDW->Security
I dont know if you know but this tells all
http://msdn2.microsoft.com/en-us/library/ms189121.aspx
ASKER
i understand what the different roles mean...
i'm just not sure why i'm getting this error. at first, i thought it was the way i have things set up in sql management studio with regards to my user account / login / schema.
but since i can execute a select statement query on that table in the management studio, i'm wondering if it's not something else... if it was a permissions issue with my user account, wouldn't i get an error when i execute a query in the management studio?
since the analysis services cube is using a data source OLE DB, perhaps the issue is there? the tutorial walked me through setting up the data source... but said nothing about having to enable specific permissions in the database for that connection.
i'm certainly no sql expert so i might be heading down the wrong path here...
here is the tutorial: http://msdn2.microsoft.com/en-us/library/ms170208.aspx
here is where it says how to configure the data source: http://msdn2.microsoft.com/en-us/library/ms167105.aspx
and here is the step i'm stuck on (deploy):http://msdn2.microsoft.com/en-us/library/ms166576.aspx
i'm just not sure why i'm getting this error. at first, i thought it was the way i have things set up in sql management studio with regards to my user account / login / schema.
but since i can execute a select statement query on that table in the management studio, i'm wondering if it's not something else... if it was a permissions issue with my user account, wouldn't i get an error when i execute a query in the management studio?
since the analysis services cube is using a data source OLE DB, perhaps the issue is there? the tutorial walked me through setting up the data source... but said nothing about having to enable specific permissions in the database for that connection.
i'm certainly no sql expert so i might be heading down the wrong path here...
here is the tutorial: http://msdn2.microsoft.com/en-us/library/ms170208.aspx
here is where it says how to configure the data source: http://msdn2.microsoft.com/en-us/library/ms167105.aspx
and here is the step i'm stuck on (deploy):http://msdn2.microsoft.com/en-us/library/ms166576.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Closed, 500 points refunded.
modus_operandi
Community Support Moderator
modus_operandi
Community Support Moderator
Closed, 500 points refunded.
modus_operandi
Community Support Moderator
modus_operandi
Community Support Moderator
ASKER