>
> Hi Gavin/Richard,
>
> I missed the beginning of this thread, but DB2 in general follows
> operating system security for allowing DB2 users to connect to the
> database. Once a connection to a database is made, access to specific
> db objects can be controlled via the SQL GRANT command.
>
> By default, db objects belong to the userid that created them and it is
> up to him/her to grant access.
>
> Not sure how sophisticated you would like to get with user mgmt, or if
> you have specific questions, but here is a link to a devworks article
> that gives a general overview on security:
>
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508wasserman/
>
>
> What is your goal? Strictly managing users or giving them free rein to
> create and manage databases?
>
> Thanks,
>
> -Sal.
>
>
> Salvador Ledezma
> IBM Silicon Valley Laboratory
> Phone: 408-463-4312 Tie Line: 8-543-4312
> Email:
[hidden email]
>
>
> *Gavin Vess <
[hidden email]>*
>
> 11/03/2006 10:50 AM
>
>
> To
> Richard Thomas <
[hidden email]>
> cc
>
[hidden email], Salvador Ledezma/Silicon Valley/IBM@IBMUS,
>
[hidden email]
> Subject
> Re: [fw-server] DB2 install
>
>
>
>
>
>
>
>
> I'm hoping our DB2 expert, Salvador, will volunteer ... :)
>
> Richard Thomas wrote:
> > Not sure if I mentioned this one, it is installed and running, not
> > sure how we should handle administration/setup of dbs for users and such.
> --
> Cheers,
> Gavin
>
> Which ZF List?
> =================
> Everything, except the topics below:
[hidden email]
>
> Authorization, Authentication, ACL, Access Control, Session Management
>
[hidden email]
>
> Tests, Caching, Configuration, Environment, Logging
>
[hidden email]
>
> All things related to databases
>
[hidden email]
>
> Documentation, Translations, Wiki Manual / Tutorials
>
[hidden email]
>
> Internationalization & Localization, Dates, Calendar, Currency, Measure
>
[hidden email]
>
> Mail, MIME, PDF, Search, data formats (JSON, ...)
>
[hidden email]
>
> MVC, Controller, Router, Views, Zend_Request*
>
[hidden email]
>
> Community Servers/Services (shell account, PEAR channel, Jabber)
>
[hidden email]
>
> Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
>
[hidden email]
>
>
> How to un/subscribe:
http://framework.zend.com/wiki/x/GgE>
>