Re: Users Logins

From: rideout (mrideout@instlab.com)
Date: 08/08/02 

From: "rideout" <mrideout@instlab.com>
Date: Wed, 7 Aug 2002 16:49:17 -0700

Can you give the website address..I can't seem to find
these online books?

Thanks..
>-----Original Message-----
>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: Getting started in IT.
    ... Have ordered both books. ... MCITP SQL Server 2005 Database Administration All-in-One Exam Guide ...
    (microsoft.public.cert.mcdba)
  • Re: SQL Server 2000 Table Properties
    ... You should find Books Online within your SQL Server program group. ... You can download the latest and greatest version from here: ...
    (microsoft.public.sqlserver.tools)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... I've spent enough $$$ on books presently and they were all ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Whats My Password?
    ... To create a SQLServer database using Server Explorer in VS2005: ... This displays the Create New SQL Server Database dialog. ... books you have used as well. ... Specifically, the database connection stuff. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Shrinking a SQL Server 6.5 db
    ... references for SQL Server 6.5. ... SHRINKDB to shrink his database? ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)