Permission to Insert records for DB USERS

From: Shailesh (shailesh@geminicorp.be)
Date: 07/26/02 

From: "Shailesh" <shailesh@geminicorp.be>
Date: Fri, 26 Jul 2002 02:55:32 -0700

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

  • Re: Complete Neophyte Question(s)
    ... I have a user named james on a database. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ... CREATE USER erik ...
    (microsoft.public.sqlserver.security)
  • RE: security problems with AD and SQL Server 2000
    ... I believe it is SQL server permission ... >The System developers group is placed into each users section of the ... >database for permitting database access to each database. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Alter Many Stored Procedures
    ... Books Online for SQL Server SP3 at ... >> What permission do I need to setup for a developer in order to change ... >> stored procedures in ABC database? ... Developer windows group is added to ...
    (microsoft.public.sqlserver.security)
  • Re: ASP page and SQL server error
    ... It's not the account, it's the priveleges that the account has with regards ... SQL Server permissions are very granular. ... while the user has permission to USE the database (in a general ...
    (microsoft.public.frontpage.programming)
  • Re: How to connect to an SQL Server 2000 Personal Edition Database
    ... You've got to give the aspnet worker process the permission to the database, add a new login from your Windows Account. ... Otherwise you've to run impersonnation or use sql authentication. ... I have created a web service that needs to access data in an SQL Server 2000 ...
    (microsoft.public.dotnet.framework.webservices)