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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
Click to expand...
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
 
Back
Top