Users and Groups
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) - Re: Users and Groups
... Have you given your groups permissions to the 'Database' object? ... > will become the member of "Users" group, ... > not have the rights. ...
(microsoft.public.access.security) - Re: DC v Heller: Amicus Brief of the Real Linguists, Part I
... Otherwise, a foreigner like Verdugo could, but Rehnquist rightly pointed out that as he was NOT a member of THE PEOPLE CLASS, he could NOT claim the right, even though he IS an individual, but NOT AN INDIVIDUAL MEMBER OF THE PEOPLE. ... But, as Rehnquist points out, the rights of the 4th Amen extend ONLY to THE PEOPLE! ... How would an 80-year-old black woman from Haiti having an "individual right" to "own and carry guns" further the security of a free state to have a well-regulated militia, when such a person would be FOUR WAYS prohibited from SERVING in the militia or VOTING for the legislature that organizes and controls it? ... OR, and this is where the BoR comes in, any rights they MAY have claimed were not PROTECTED or GUARANTEED by the Constitution! ...
(talk.politics.guns) - 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) |
|
