Re: Users and Groups



Have you given your groups permissions to the 'Database' object?

www.keithwilby.com

"calyntan" <calyntan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35C808C8-4169-4AAB-8451-B47B99CE4704@xxxxxxxxxxxxxxxx
> Hi, I have a database where I need to create 2 different groups which has
> different Access type. However, I noticed that by default, all users
> created
> will become the member of "Users" group, which I cannot remove. So, the
> problem now is that when I create 2 groups, Devt and Support, both with
> different access rights and assign user to be a member of their respective
> groups, and I removed all permission from the "Users" group. Upon doing
> that,
> looks like all user can't access into the database telling them that they
> do
> not have the rights. How can I set such a security that provide different
> rights to the user in different group?


.



Relevant Pages

  • Re: Lock out 1 user within Enterprise Manager
    ... >Don't give the user sysadmin privileges on the database. ... >Make this person a member of the datareader role in the ... >> to restrict rights because they'll definitely come tell ...
    (microsoft.public.sqlserver.security)
  • Re: Find a record when Form opens
    ... You create a new User so he can use the database. ... If you have the president's user account as a member of different ... groups, you can give him different rights, and use a function or ... do, and it would look just like a normal Access DB, but they can only ...
    (comp.databases.ms-access)
  • Users and Groups
    ... I have a database where I need to create 2 different groups which has ... different Access type. ... will become the member of "Users" group, ... not have the rights. ...
    (microsoft.public.access.security)
  • Re: HOME BASED JOB OPPORTUNITY - MAKE MILLIONS WITH Rs.60!
    ... Free entry into draw. ... > THIS CAN REALLY MAKE YOU EASY MONEY! ... Try to Remember that you don`t change the Main Database ... > mail/courier with money to the main member and to the other 5 upline ...
    (soc.culture.indian.gujarati)
  • Re: HOME BASED JOB OPPORTUNITY - MAKE MILLIONS WITH Rs.60!
    ... Free entry into draw. ... > THIS CAN REALLY MAKE YOU EASY MONEY! ... Try to Remember that you don`t change the Main Database ... > mail/courier with money to the main member and to the other 5 upline ...
    (soc.culture.indian.karnataka)