However, there is also a pseudo-role named PUBLIC that you can grant
rights to and all users get the privileges granted to PUBLIC.
plus there was a (bug/feature?) in 1.5 where any user who logged in
with lower case username but with the correct password has been
granted PUBLIC
On 08/12/2012 09:21 pm, Doug Chamberlin wrote:
On 12/8/12 9:27 AM, Venus Software Operations wrote:
Does this mean if a user themself are grants few rights (RightsA) only
and I login via this user but no role that is all they can do.
Basically, yes. When a user logs in in with no role they
Thanks Andre
So just creating a user does not allow them to do much. So either I can
grants various accesses to the user themself or via roles (which is the
best idea for me atleast).
Kind regards
Bhavbhuti
On 07/12/2012 04:09 pm, André Knappstein wrote:
Role privileges == additional
On 07/12/2012 07:03 pm, Doug Chamberlin wrote:
On 12/7/12 2:36 AM, Venus Software Operations wrote:
What does the default blank role for sysdba mean?
That if the data-entry user if they login without a role will have the
same powers as sysdba?
No. Roles attach additional privileges to the
Role privileges == additional privileges.
No Role == no additional privileges.
On 06/12/2012 07:11 pm, Doug Chamberlin wrote:
Don't forget you also have to change the application to have each user
login using the new role.
Will do. Thanks, this is interesting, all this is new terrain for
On 12/7/12 2:36 AM, Venus Software Operations wrote:
Does it mean that a single user can login using various roles that may
have been setup?
Yes. If a user has been granted several roles then any one of those
roles can be used by that user when connecting to the database. The user
can also have
On 12/6/12 2:29 AM, Venus Software Operations wrote:
Thanks Andre your suggestions are appreciated.
I have created the role and provided the privileges to this role. Now it
should be a matter to transfering this role and it's privileges (which I
am presently working on in the utility) to
On 06/12/2012 07:11 pm, Doug Chamberlin wrote:
Don't forget you also have to change the application to have each user
login using the new role.
Will do. Thanks, this is interesting, all this is new terrain for me.
Does it mean that a single user can login using various roles that may
have
Thanks Andre your suggestions are appreciated.
I have created the role and provided the privileges to this role. Now it
should be a matter to transfering this role and it's privileges (which I
am presently working on in the utility) to the production database and
assign users there.
Kind
Yes, that basically is how it works; at least for me :-)
I do assign new users to a given role, sometimes to more than one
role. This can be done using DML.
The administrator on site (which happens to be myself in my case *g*)
only has to set up the client logic (for example creating
Hi all
Presently I do not create users in FireBird and rely on the sysdba login to
auto update data structures and user data-entry from the application. I know
this is not good but had to get things forward.
I need a couple of types of users in FireBird. One, are the data-entry users.
They
Thanks Andre for your views. I think I am getting an idea on how I might
go about your suggestion to RL_Writers, which I can create on the
development database copy. This role then can be taken to the production
database via the utility that manages other DML operations.
The users that are
12 matches
Mail list logo