Re: Users Logins

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 08/07/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 07 Aug 2002 14:03:54 -0600

You need to grant the users permissions to objects in a
database - objects such as tables, views, stored procedures,
user defined functions. You really would want to review the
security topics in books online in order to be able to
manager this. I don't think it can be fully explained in a
newsgroup post. If you go into SQL Server books online,
under Administering SQL Server, there is a subtopic called
Managing Security. You will want to read through that to get
an understanding of how SQL Server security works.

-Sue

On Wed, 7 Aug 2002 11:12:34 -0700, "RIDEOUT"
<mrideout@instlab.com> wrote:

>Hello,
>how do I setup up users to access my database?
>
>I already have the users accessing things in the SQL
>server envirmoment, but when I login using my front end
>(access data project) once try to access the store
>produceers, I get an error stating that I cannot open the
>procedure.
>
>I am wondering how do I get the users I want to do what I
>want..meaning I have 2 users joe and ann.
>Joe is allowed to insert, and view stuff in the database ,
>and ann canONLY read/view things in teh database..
>HOW DO I DO THIS??
>
>THANKS IN ADVANCE,
>RIDEOUT

Relevant Pages

  • Re: Database Model - Class, objects and interaction
    ... I was just proving stored procedures can call views. ... stuff like security and logging. ... So given 100,000 users, you would create database accounts for each? ... Part of our system's integrity was its reliability, and reliability is often assisted by simplicity. ...
    (comp.object)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... SQL Server 2000 Out-of-the-Box database security solution. ... database protection and privacy software is an industry-proven ...
    (microsoft.public.sqlserver.security)
  • Re: SQL or Access DB
    ... i am aware of the security modell of SQL server (we do use SQL server ... an end user,,, there is not reall alternative as a worgroup Access database ... MSDE and SQL express are all free ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)