Database with right Privileges & ADO.NET (ASP.NET Application)

12 May 2006 5:03 PM

ss

Hi,

Can anybody tell me like how do I create a database object like table where
a user should have only read permissions?

Before that, which account I should create so that I can use in my ASP.NET
web application.

How do I control like a perticular user only should execute perticular
stored procedure?

How do I give / show my privilege in the ADO.NET while executing the
relevent stored procedure?

bye
ss

13 May 2006 8:02 AM

Cor Ligthert [MVP]

SS,

Database table permissions are not managed in a program. That is done in the
database by using the settings for that.

The Account for ASPNET is the user ASPNET.

However this is more SQL management than ADONET stuff. And therefore you use
the SQL management instrumentarium.

I think that the real experts for that are in a SQL Server newsgroup.
Although they are as well here, do you have in the weekend for that less
change.

AdoNet can only see that something is not executed. Than you can catch that
in a Try Catch block why it is, I don't know how far the messages go for
that. Have a look yourself for that by SQL exceptions.

http://msdn2.microsoft.com/en-us/library/ms162127.aspx

I hope this helps sofar

Cor

Show quote

"ss" <s*@discussions.microsoft.com> schreef in bericht
news:E1BBF646-0C6D-437A-B834-A476274FABBD@microsoft.com...
> Hi,
>
> Can anybody tell me like how do I create a database object like table
> where
> a user should have only read permissions?
>
> Before that, which account I should create so that I can use in my ASP.NET
> web application.
>
> How do I control like a perticular user only should execute perticular
> stored procedure?
>
> How do I give / show my privilege in the ADO.NET while executing the
> relevent stored procedure?
>
> bye
> ss

13 May 2006 12:31 PM

Otis Mukinfus

On Fri, 12 May 2006 10:03:01 -0700, ss <s*@discussions.microsoft.com> wrote:

Show quote

>Hi,
>
>Can anybody tell me like how do I create a database object like table where
>a user should have only read permissions?
>
>Before that, which account I should create so that I can use in my ASP.NET
>web application.
>
>How do I control like a perticular user only should execute perticular
>stored procedure?
>
>How do I give / show my privilege in the ADO.NET while executing the
>relevent stored procedure?
>
>bye
>ss

These are issues that must be handled from the SQL Server Enterprise Manager.
You will improve your chances of getting an answer by posting to one of those
news groups. Although, you might want to type TSQL into the IDE's Help section
and then look for the keywords regarding your questions which are basic SQL
Server security questions.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com