Re: SQL Adapter -Stored Procedure Permissions- issue, -SQL 2005-

Permissions were granted on the table, and all is well.
Thanks.


On Apr 3, 5:01 pm, "tburk" <fishingro...@xxxxxxxxxxx> wrote:
Our SQL security requires that Users have permission to execute stored
procedures. We do this by adding BTSService user within the SQL 2005
'Security Users' of the database, then we add that user to a 'Roles
Database Roles' such as 'db_approle' that is assigned to the
individual stored procedure and is then granted 'Execution'
privileges. You can see where the permissions are applied if you
right click any stored procedure and select 'Properties'. This works
quite nicely when schemas are created within BizTalk 2006 using the
SQL Adapter schema generation wizard and when the schema is created
from a stored procedure.

Here is the question. Within this framework, and when an UpdateGram
schema is created/used, how can privileges be granted to allow the
UpdateGram to access the DB? Here is the log entry showing the denial
when an UpdateGram was executed.

Error Description: HRESULT="0x80040e09" Description="UPDATE permission
denied on object 'CIPAssets', database 'CIP', schema 'dbo'."
HRESULT="0x80040e09" Description="SELECT permission denied on object
'CIPAssets', database 'CIP', schema 'dbo'."

Thank you,
Tom


.

Relevant Pages

  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)