Permissions for database

From: Michel (karnish@bezeqint.net)
Date: 08/21/02


From: "Michel" <karnish@bezeqint.net>
Date: Wed, 21 Aug 2002 04:12:32 -0700


Hi!
We have several databases on SQL-Server with a number of
developers. To define a user to access to a database we
make him a local administrator on a server. We'd like to
change this to something more useful as defining
permissions for developers without making'em
administrators. We tried to define login for a database,
but it hasn't succeeded.
We'd appretiate any help from you on the issue above.
Thanks in advance.



Relevant Pages

  • Re: Datebase needed for tracking of drugs for a fire department!
    ... including for MS Access database development. ... There are good developers, don't get me wrong, but one has to ... Excel makes you think in math calculations. ... Shelf life of the drug could be loaded once and then access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: WHY
    ... I've been working a lot longer than that LoL ... re-creating the same spreadsheet, ... > I'm sure the database admins do all the work at, say, Boeing and Airbus, ... > Or perhaps you meant implicitly to restrict your remarks to developers. ...
    (microsoft.public.excel)
  • Re: compilers
    ... Pick is superb for the database and the business rules, ... I'll be happy to look hard at OpenQM if I ... This means that whatever back-end database I have to use needs to support ... positions that I do because they are developers, ...
    (comp.databases.pick)
  • Re: Need help on how to organize users and objects
    ... I could assign a custom database role to them though. ... In 2005, if a user creates an sp, which schema does it belong to? ... Security is a huge subject in SQL Server 2005, so I'd suggest you to spend ... the sysadmin; developers and viewers. ...
    (microsoft.public.sqlserver.security)
  • ANN: kbmMW v. 2.01 released
    ... The latest edition of kbmMW adds to the existing WIB by now allowing for hub/spoke topology in addition to the normal ... the developers API is the same as if traditional request/response communication setups are used. ... - multi database transactional support. ...
    (borland.public.delphi.thirdpartytools.general)