[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

Creating Database roles and logins for VB - Application

Hi,

I have created an application iusing VB / Sql Server 2000.

I have also created an application role (name : VBAPI) in the database with only select permissions.

How can | assign the application I have developed to this Application role ?

Thanks and Best regards,

Sreejith
0
sreejithm
Asked:
sreejithm
1 Solution
 
StGoYCommented:
sp_addsrvrolemember
Adds a login as a member of a fixed server role.

Syntax
sp_addsrvrolemember [ @loginame = ] 'login'
    , [ @rolename = ] 'role'

Am not quite sure this is what you are looking for though...  You can't give SQL permissions to an application... ??

Quite confusing ;)

Steph
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now