How can I assign user permission

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I assign user and group by user-level security wizard like these

Group User
Admins Admin
Full data user AAAAA, BBBBB, CCCCC
New data user DDDDD

and then I try to use user and group permission to limit some permission of
CCCCC
to open some forms by click open/runin permission box to deselect form.

I have Form1, Form2,,,,,,,,,,, Form10

I try to deselct Form6 and Form7

After I log on in name of CCCCC, I still open form6 and form 7 like user
AAAAA and BBBBB, Why am I wrong ?
 
First, Admin should not be a member of the Admins Group. You should create
a new user to be a member of Admins, and remove Admin from that group.

You likely assigned permissions to the CCCCC user. However they are still a
member of the 'Full data user' group, and therefore have the permissions for
that group. Permissions that a user inherits from a group do not show up in
the security dialogs. Only explicit permissions show for the user.

You'd need to create a separate group that doesn't have permission on Form6
and 7 and make CCCCC a member of that group.
 
Thankyou for your answer but I have a new problem in assign new user.

I create a new group (GPNew) by menu users and group account then create new
user (EEEEE) in GPNew after that I cannot log on to database in user name
EEEEE, I don't know why?. But I can log on by others user name normally, but
if I remove user AAAAA,BBBBB or CCCCC form full data user group and then put
in GPNew group I cannot log on to database why? and Where am I wrong?
 
When you create a user via the Tools, security, Accounts menu, you supply a
username and PID. The PID is not a password.

Try logging in as the new user with no password.

(You can then set a password for the user via the Tools, security, Accounts
menu.

You created the earlier users via the security wizard, which does offer the
opportunity to set a user password.
 
Back
Top