Subject Re: Users and Roles Problem
Author w_y_v_i_s
Another quick question about roles...

Is there any way to remove object creation rights from a user role?

I see there are object level (e.g. select, update, delete etc)
privileges but what about database level privileges (e.g. create
table, create procedure etc)? How do I restrict these for a user's role?

Thanks again for any help.

--- In firebird-support@yahoogroups.com, "w_y_v_i_s" <alanyuill@y...>
wrote:
>
> --- In firebird-support@yahoogroups.com, Jaimy Azle <nospam@l...> wrote:
> > On Wednesday, January 12, 2005, 10:29:05 PM, w_y_v_i_s wrote:
> >
> > > I am a firebird newbie and I am having a few problems with users and
> > > roles. Simple scenario: I want to create a DB, add a table,
create a
> > > role with privileges and finally create a new user with the role.
> >
> > > Step 4: Login as user and try it
> > > Use CONNECT or CREATE DATABASE to specify a database
> > > SQL>> connect "D:\ROLETEST.FDB" user TESTUSER password t3stus3r;
> > > Database: "D:\ROLETEST.FDB", User: TESTUSER
> > > SQL>> select * from COUNTRIES;
> > > Statement failed, SQLCODE = -551
> > > no permission for read/select access to TABLE COUNTRIES
> >
> > Just specify which role should be used when login, this because you
> > can assign multiple roles for testuser.
> >
> > SQL> connect "D:\ROLETEST.FDB" user TESTUSER password t3stus3r role
> > CON> testrole;
> >
> > --
> > Salam,
> >
> > -Jaimy Azle
>
> I knew it would be something easy like that.
>
> Thanks!