Hi Folks!

with exec sp_addapprole ... it is posible to create a new Application Role Security with TSQL.
Bud I can't find any way to specify the rights for this role by TSQL.

Is there a way to do this?

Thanks for any suggestions