Problem with Application Roles

[jobyk]

Hi Friends

I am trying to use application role based priviliges to my users. After connecting to the database (SQL) through windows authentication, I have set the application role by executing the sp_setapprole stored procedure. I am getting rights for executing a query for once. When I am running a second query it returns an error. Pl. help me.
Thanks in advance.

Joby

 

[fredericofonseca]

and what is your code and what is the error you are getting?



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[jobyk]

mycon.open Provider=SQLOLEDB.1;Integrated Security=SSPI;OLE DB Services = -2;Persist
Security Info=False;Initial Catalog=Products;Data Source=local
mycon.execute "sp_setapprole 'productrole','password'"
set rs=mycon.execute("select * from product")
set rs1=mycon.execute("select * from product")


The first query works fine. Second query returns authentication error.

Product role is an application role which gives rights on product table.

Thanks in advance
Joby

 

[gmmastros]

Look at the following...

http://www.sqlservercentral.com/col...rversecurityprosandconsofapplicationroles.asp

thread183-1016951


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom