Friday, February 24, 2012

EXECUTE permission denied on object

I've taken over a project where the datasets are running stored
procedures on a database that I don't have permissions to execute
stored procedures.
I've changed the shared data source to a database I can use but I'm
getting the above message that still refers to the original database.
I don't know of anywhere else that I need to change.
Any ideas?andy
Grant EXECUTE permissions on the object. However , if a stopred procedure
uses dynamic sql within , you'll have to grant SELECT/UPDATE/DELETE
permissions on the undelaying tables as well
<andy.williams1971@.ntlworld.com> wrote in message
news:1162977266.829057.169620@.b28g2000cwb.googlegroups.com...
> I've taken over a project where the datasets are running stored
> procedures on a database that I don't have permissions to execute
> stored procedures.
> I've changed the shared data source to a database I can use but I'm
> getting the above message that still refers to the original database.
> I don't know of anywhere else that I need to change.
> Any ideas?
>|||What do you mean grant EXECUTE permissions on the object? I am new to
Reporting services and have a very limited programming knowledge, and
unfortunately there is nobody on site who knows Reporting Services.
I work in an environment which I have full permissions to
execute/create/delete stored procedures. This environment is called
'Rules'. The initial database (to which I have no access, and am not
allowed access) is called 'Dev'. I've changed the datasource from Dev
to Rules but I'm getting the error message EXECUTE permissions denied
on object ........., database 'dev', owner 'dbo'
Uri Dimant wrote:
> andy
> Grant EXECUTE permissions on the object. However , if a stopred procedure
> uses dynamic sql within , you'll have to grant SELECT/UPDATE/DELETE
> permissions on the undelaying tables as well
>
>
> <andy.williams1971@.ntlworld.com> wrote in message
> news:1162977266.829057.169620@.b28g2000cwb.googlegroups.com...
> > I've taken over a project where the datasets are running stored
> > procedures on a database that I don't have permissions to execute
> > stored procedures.
> >
> > I've changed the shared data source to a database I can use but I'm
> > getting the above message that still refers to the original database.
> > I don't know of anywhere else that I need to change.
> >
> > Any ideas?
> >|||Andy
Right click on the stored procedure and click Properties. At the left -top
click on Permission button and click Execute for specific user
<andy.williams1971@.ntlworld.com> wrote in message
news:1162978403.280403.69650@.e3g2000cwe.googlegroups.com...
> What do you mean grant EXECUTE permissions on the object? I am new to
> Reporting services and have a very limited programming knowledge, and
> unfortunately there is nobody on site who knows Reporting Services.
> I work in an environment which I have full permissions to
> execute/create/delete stored procedures. This environment is called
> 'Rules'. The initial database (to which I have no access, and am not
> allowed access) is called 'Dev'. I've changed the datasource from Dev
> to Rules but I'm getting the error message EXECUTE permissions denied
> on object ........., database 'dev', owner 'dbo'
>
> Uri Dimant wrote:
>> andy
>> Grant EXECUTE permissions on the object. However , if a stopred procedure
>> uses dynamic sql within , you'll have to grant SELECT/UPDATE/DELETE
>> permissions on the undelaying tables as well
>>
>>
>> <andy.williams1971@.ntlworld.com> wrote in message
>> news:1162977266.829057.169620@.b28g2000cwb.googlegroups.com...
>> > I've taken over a project where the datasets are running stored
>> > procedures on a database that I don't have permissions to execute
>> > stored procedures.
>> >
>> > I've changed the shared data source to a database I can use but I'm
>> > getting the above message that still refers to the original database.
>> > I don't know of anywhere else that I need to change.
>> >
>> > Any ideas?
>> >
>|||I'm sorry for being useless, but I've looked on the data tab and I
cannot get the properties window for the stored procedure
Uri Dimant wrote:
> Andy
> Right click on the stored procedure and click Properties. At the left -top
> click on Permission button and click Execute for specific user
>
> <andy.williams1971@.ntlworld.com> wrote in message
> news:1162978403.280403.69650@.e3g2000cwe.googlegroups.com...
> > What do you mean grant EXECUTE permissions on the object? I am new to
> > Reporting services and have a very limited programming knowledge, and
> > unfortunately there is nobody on site who knows Reporting Services.
> >
> > I work in an environment which I have full permissions to
> > execute/create/delete stored procedures. This environment is called
> > 'Rules'. The initial database (to which I have no access, and am not
> > allowed access) is called 'Dev'. I've changed the datasource from Dev
> > to Rules but I'm getting the error message EXECUTE permissions denied
> > on object ........., database 'dev', owner 'dbo'
> >
> >
> >
> > Uri Dimant wrote:
> >> andy
> >> Grant EXECUTE permissions on the object. However , if a stopred procedure
> >> uses dynamic sql within , you'll have to grant SELECT/UPDATE/DELETE
> >> permissions on the undelaying tables as well
> >>
> >>
> >>
> >>
> >> <andy.williams1971@.ntlworld.com> wrote in message
> >> news:1162977266.829057.169620@.b28g2000cwb.googlegroups.com...
> >> > I've taken over a project where the datasets are running stored
> >> > procedures on a database that I don't have permissions to execute
> >> > stored procedures.
> >> >
> >> > I've changed the shared data source to a database I can use but I'm
> >> > getting the above message that still refers to the original database.
> >> > I don't know of anywhere else that I need to change.
> >> >
> >> > Any ideas?
> >> >
> >|||I meant you have Enterprise Manager Tool installed on the computer.
<andy.williams1971@.ntlworld.com> wrote in message
news:1162981702.059182.305600@.k70g2000cwa.googlegroups.com...
> I'm sorry for being useless, but I've looked on the data tab and I
> cannot get the properties window for the stored procedure
> Uri Dimant wrote:
>> Andy
>> Right click on the stored procedure and click Properties. At the
>> left -top
>> click on Permission button and click Execute for specific user
>>
>> <andy.williams1971@.ntlworld.com> wrote in message
>> news:1162978403.280403.69650@.e3g2000cwe.googlegroups.com...
>> > What do you mean grant EXECUTE permissions on the object? I am new to
>> > Reporting services and have a very limited programming knowledge, and
>> > unfortunately there is nobody on site who knows Reporting Services.
>> >
>> > I work in an environment which I have full permissions to
>> > execute/create/delete stored procedures. This environment is called
>> > 'Rules'. The initial database (to which I have no access, and am not
>> > allowed access) is called 'Dev'. I've changed the datasource from Dev
>> > to Rules but I'm getting the error message EXECUTE permissions denied
>> > on object ........., database 'dev', owner 'dbo'
>> >
>> >
>> >
>> > Uri Dimant wrote:
>> >> andy
>> >> Grant EXECUTE permissions on the object. However , if a stopred
>> >> procedure
>> >> uses dynamic sql within , you'll have to grant SELECT/UPDATE/DELETE
>> >> permissions on the undelaying tables as well
>> >>
>> >>
>> >>
>> >>
>> >> <andy.williams1971@.ntlworld.com> wrote in message
>> >> news:1162977266.829057.169620@.b28g2000cwb.googlegroups.com...
>> >> > I've taken over a project where the datasets are running stored
>> >> > procedures on a database that I don't have permissions to execute
>> >> > stored procedures.
>> >> >
>> >> > I've changed the shared data source to a database I can use but I'm
>> >> > getting the above message that still refers to the original
>> >> > database.
>> >> > I don't know of anywhere else that I need to change.
>> >> >
>> >> > Any ideas?
>> >> >
>> >
>|||> I've changed the shared data source to a database I can use but I'm
> getting the above message that still refers to the original database.
Are you running the report through the VS IDE or after deployment? If you
change the data source and run the report from the IDE, the new database
should be used and reflected in any error messages. However, when you
deploy a report, existing data sources on the report server are not
overwritten unless you specify 'true' for the data source overwrite
property.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<andy.williams1971@.ntlworld.com> wrote in message
news:1162977266.829057.169620@.b28g2000cwb.googlegroups.com...
> I've taken over a project where the datasets are running stored
> procedures on a database that I don't have permissions to execute
> stored procedures.
> I've changed the shared data source to a database I can use but I'm
> getting the above message that still refers to the original database.
> I don't know of anywhere else that I need to change.
> Any ideas?
>

No comments:

Post a Comment