Improve company productivity with a Business Account.Sign Up

x
?
Solved

Creating Database roles and logins for VB - Application

Posted on 2004-08-12
3
Medium Priority
?
198 Views
Last Modified: 2010-04-17
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
Comment
Question by:sreejithm
1 Comment
 
LVL 3

Accepted Solution

by:
StGoY earned 200 total points
ID: 11796744
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This article describes and provides a custom-made tool I wrote to give businesses a means of identifying commercial music content, without having to expend too much effort. Business recordings are easily identified from possibly illegal music files …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Screencast - Getting to Know the Pipeline

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question