Posted by Marcin A. Guzowski on 08/16/07 13:08

rhaazy pisze:
> I am trying to a simple insert statement from a remote application
> against a sql server 2005 database. To fix the problem I was having,
> I had to grant the Login I was using the role of sysadmin. However I
> don't want this user to have that kind of control, what would be the
> best role to allow the user full access(including remoting) to only
> one particular database?

First, tell us what the problem was (provide an error message or other
details).

You can configure detailed permissions in SQL Server 2005, granting
sysadmin server role is far too much. Grant the login only enumerated
permissions that are essential to perform certain tasks (simple insert
in your case). Here is an T-SQL statement to do it:

GRANT INSERT ON your_table TO some_user;

Of course there are alternate solutions - e.g. database role
(db_datawriter), but try that one I mentioned above.


--
Best regards,
Marcin Guzowski
http://guzowski.info

• Next in forum: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
• Prev in forum: ODBC Timeout problems but very hard to pin down
• Thread view: Re: Problem performing remote queries

[Reply to this message]