Re: securing seperate databases under one instance

> Can someone tell me how to secure each database
> so that the other vendor does not have access to each others database?
> For

Lookup sp_revokedbaccess stored procedure in the BOL


"Sher" <Sher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:665EC2AB-FEE7-454A-8F3E-98ED8B2314C7@xxxxxxxxxxxxxxxx
> Hi all,
> I have sql2000 with one instance installed. I have two seperate databases
> from two seperate vendors. Can someone tell me how to secure each
> database
> so that the other vendor does not have access to each others database?
> For
> example the first vendor has an active directory logon with power users
> rights, but now I need to secure the database tables ect under enterprise
> manager. Where do I setup the user rights for that vendor since he can
> logon
> to the sql server itself and needs rights to the enterprise manager.
> I know I can setup a second instance but am worried about the overhead of
> two instances running.
> Thanks in advance for any help or guidance on this.
> I have a dell poweredge 2800 with 2gig memory and 2.80 gzh zeon processor.
> Sher


.

Relevant Pages

  • Re: Poly Couples
    ... If you want to claim that OO is the consolution prize for lame database ... there is a metamodel which describes the hierarchy. ... Metamodel is stored in SQL, however, the data is stored in non ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: Poly Couples
    ... business software" example mentioned in this thread. ... But the communication mechanism with the database remains the same. ... That doesn't mean that other languages (such as sql, ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: Need expert coding help with a debugging issue.
    ... If you are declaring by default a recordset or database as a variant you may not get the hoped-for result. ... even if it works to jump to End With (at LocationEnd), ... code that tells the user exactly which bin location he or she should put the ... The bins are sorted by vendor. ...
    (microsoft.public.access.formscoding)
  • Re: help with object design for a database
    ... and load it on the database or throw an error. ... If I type in a serial number, the system will detect the format of the ... Why three tables in the RDB? ... Presumably you only have to do this when the vendor ...
    (comp.object)