473,385 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

SQLServer Login as sa vs dbo

3
I need to connect to db and grant rights of only db owner so as to prevent any security breach but at the same time , my application needs to run certain jobs,, for which i need sa rights. Please suggest a solution. how to go abt it.. I need to write a script to ask - to whom do we want to assign sa rights and dbo rights, using parameters as user and role.
Mar 20 '07 #1
2 6085
iburyak
1,017 Expert 512MB
I didn't test it but you might try to create a stored proc to run jobs which accepts necessary parameters. Stored proc must be created by SA and grant execute rights to this proc to DBO users.

Hope it works.
Mar 20 '07 #2
ansz5
3
which is the role with minimum permissions including a one to execute jobs.
Mar 20 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Jim Corey | last post by:
We're looking at logging on to SQLServer using Windows Authentication from an ASP app, and trying to figure out what will work. The following connection string works with Basic Authentication:...
0
by: Kristofer Liljeblad | last post by:
Hi, I've successfully setup my machine to use: sessionState mode="SQLServer". All is up and running so no problems so far. Because I curious person, I started to play around with the two new...
2
by: Papa_K | last post by:
I want to connect from a .net web server to a sqlserver. i read an article a while ago on how to do this but i have since 'filed' it and no longer can i find it. i remember that i was able to...
11
by: Patrick | last post by:
I have an ASP.NET application that connects to a SQL Server database. The SQL Server resides on a seperate development server from the IIS5.1 on Windows XP SP2 on development PCs which host the...
2
by: waqarkust | last post by:
What is the diffrence between Sql Server Login and Sql server Database User? I want to put a funtionality in my application from where administartor make Application User. these application user...
2
by: dgk | last post by:
I'm using the standard provider for membership which is SQLServer Express. After deploying the app to our server, login fails because of an SQL problem. I'm guessing that the problem is that the...
2
by: =?Utf-8?B?SmVmZnJleQ==?= | last post by:
How to configure the IIS, ASPNET userID, Windows or SQL Authentiation, std or integrated security for SQLserver database? The VS.net 2002 web server and SQL Server client are at the same PC, ...
2
by: ramaswamynanda | last post by:
Hello All, I have an application using ASP.NET. The database is SQLServer Express 2005. There is a table called ApartmentInfo in the database. All i am trying to do, is to "select * from...
21
by: adjo | last post by:
I am working on an app with an Access2002 frontend and Sql2005 backend. I have to use integrated security. I want to prevent my users from altering data in another way than via the frontend. It...
0
by: selvamariappan | last post by:
Hi all, How to find login name and password for sqlserver 2005 in sql server authentication mode, In my sys i have installed .net and then i have installed sqlserver express, i want...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.