Re: Permission to Insert records for DB USERS

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 07/26/02 

From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Fri, 26 Jul 2002 11:45:03 +0100

You could use the GRANT command to grant INSERT permissions to users.

Or, you could add your user to db_datawriter role, as it lets users add,
delete, modify data.

Better yet, do not grant any direct permissions to users. Write stored
procedures for your data updation needs, and grant EXECUTE permissions on
your procedures to your users.

See SQL Server Books Online for more information. The following link might
help as a concise reference:
http://vyaskn.tripod.com/sql_server_security_best_practices.htm 

--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/
"Shailesh" <shailesh@geminicorp.be> wrote in message
news:14dc01c2348a$9497c220$9ae62ecf@tkmsftngxa02...
> Dear Friends
>
> I am a fresh developer for the SQL server and have no Idea
> for the permissions on the database.
>
> I have created a database Master on which i can give the
> permission to the user to connect to the tables and to the
> database but the users are not able to insert or Update
> the records kindly suggest where i have to give the
> necessary permission so that my users can start inserting
> records.
>
> Your help in any positive dircetion for the solution of
> problem is needed.
>
> Best regards
> Shailesh
>

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • RE: user permissions in a database as a whole or tables
    ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: user permissions in a database as a whole or tables
    ... like PDF better but that was not helping this time either. ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: I dont understand user permissions for table access
    ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
    (microsoft.public.sqlserver.server)