By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,128 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Login Security Question

P: n/a
Hi All,

I have never tried to restrict what a person has access (Not Intended As A Joke) to. But my current class assignment requires that I present specialized switchboards to users based upon their credentials. The switchboards are not the problem - creating users, groups, etc. is. And then to deploy this system after they first log in, I expect, is another matter altogether.

For example, the den leader would need the ability to monitor everything in the database, including setting up the troop in the first place. He also creates users and groups, and is in charge of passwords. Then he creates users who perform various tasks within the troop.

For example, one of the cub scouts takes role at each meeting, and should only gain access to forms and reports pertaining to attendance.

Another boy takes care of recording whether they earned a particular badge, and then making sure someone orders it, and eventually pins it on who earned it.

This feels typical to the things most of you professionals do every day. And though mine is a labor of love, it still covers the same ground you have already covered. As a consequence, I would be overwhelmingly grateful if someone has already developed something along these lines would zip up the whole thing and send it to me.

Thanks a 1,000,000
Chuck
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Br
Chuck Insight <j.*******@insightbb.com> wrote:
Hi All,

I have never tried to restrict what a person has access (Not Intended
As A Joke) to. But my current class assignment requires that I
present specialized switchboards to users based upon their
credentials. The switchboards are not the problem - creating users,
groups, etc. is. And then to deploy this system after they first log
in, I expect, is another matter altogether.

For example, the den leader would need the ability to monitor
everything in the database, including setting up the troop in the
first place. He also creates users and groups, and is in charge of
passwords. Then he creates users who perform various tasks within the
troop.

For example, one of the cub scouts takes role at each meeting, and
should only gain access to forms and reports pertaining to
attendance.

Another boy takes care of recording whether they earned a particular
badge, and then making sure someone orders it, and eventually pins it
on who earned it.

This feels typical to the things most of you professionals do every
day. And though mine is a labor of love, it still covers the same
ground you have already covered. As a consequence, I would be
overwhelmingly grateful if someone has already developed something
along these lines would zip up the whole thing and send it to me.

Thanks a 1,000,000
Chuck


Do your own homework! :) It's all on the Net and the Access help file
already.

Lookup MS's whitepaper on how to set up security then look at the
CurrentUser() function.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #2

P: n/a
This is a very tall order for sure, but very do-able using User Level Security.
If you have never used ULS you must, not an option, read a lot of material
on the subject. It can be a difficult concept to grasp the first couple of
times. Practice on dummy databases until you really have a feel for it.

Having someone send you a working example will do you a disservice
on this subject. You must understand what is going on behind the scenes
with ULS, otherwise you will most likely screw things up. Not to mention
you will not have an answer when the instructor asks,
"Explain to me how you set this part up..."

Read all of the ULS information I have accumulated here on my site
(yes, read it ALL):

http://home.bendbroadband.com/conrad....html#Security

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"Chuck Insight" wrote in message:
news:tg2ue.90644$xm3.8631@attbi_s21...

Hi All,

I have never tried to restrict what a person has access (Not Intended As A Joke) to. But my current
class assignment requires that I present specialized switchboards to users based upon their
credentials. The switchboards are not the problem - creating users, groups, etc. is. And then to
deploy this system after they first log in, I expect, is another matter altogether.

For example, the den leader would need the ability to monitor everything in the database, including
setting up the troop in the first place. He also creates users and groups, and is in charge of
passwords. Then he creates users who perform various tasks within the troop.

For example, one of the cub scouts takes role at each meeting, and should only gain access to forms
and reports pertaining to attendance.

Another boy takes care of recording whether they earned a particular badge, and then making sure
someone orders it, and eventually pins it on who earned it.

This feels typical to the things most of you professionals do every day. And though mine is a labor
of love, it still covers the same ground you have already covered. As a consequence, I would be
overwhelmingly grateful if someone has already developed something along these lines would zip up
the whole thing and send it to me.

Thanks a 1,000,000
Chuck

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #3

P: n/a
Br
Jeff Conrad <je***@ernstbrothers.com> wrote:
This is a very tall order for sure, but very do-able using User Level
Security. If you have never used ULS you must, not an option, read a
lot of material
on the subject. It can be a difficult concept to grasp the first
couple of times. Practice on dummy databases until you really have a
feel for it.

Having someone send you a working example will do you a disservice
on this subject. You must understand what is going on behind the
scenes
with ULS, otherwise you will most likely screw things up. Not to
mention
you will not have an answer when the instructor asks,
"Explain to me how you set this part up..."

Read all of the ULS information I have accumulated here on my site
(yes, read it ALL):

http://home.bendbroadband.com/conrad....html#Security


Or you can make up a "pretend" security system where users login using a
simple form and user data is stored in a simple table.... not secure but
enough to fool basic users for non-critical data.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #4

P: n/a
"Br@dley" wrote in message:
news:J6***************@news-server.bigpond.net.au...
Or you can make up a "pretend" security system where users login using a
simple form and user data is stored in a simple table.... not secure but
enough to fool basic users for non-critical data.


Yep, very possible.
A working sample here:

http://members.shaw.ca/glenk/access2000.html
(Look for Security & Log On Demo Database For Access2000 (Richard Rensel)

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #5

P: n/a
"Br@dley" wrote in message:
news:J6***************@news-server.bigpond.net.au...
Or you can make up a "pretend" security system where users login using a
simple form and user data is stored in a simple table.... not secure but
enough to fool basic users for non-critical data.


Yep, very possible.
A working sample here:

http://members.shaw.ca/glenk/access2000.html
(Look for Security & Log On Demo Database For Access2000 (Richard Rensel)

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #6

P: n/a
Hi Jeff,
Got it - I'll look it over and see whether it will work in this environment.
Thanks very much,
Chuck

"Jeff Conrad" <je***@ernstbrothers.com> wrote in message
news:42**********@spool9-west.superfeed.net...
"Br@dley" wrote in message:
news:J6***************@news-server.bigpond.net.au...
Or you can make up a "pretend" security system where users login using a
simple form and user data is stored in a simple table.... not secure but
enough to fool basic users for non-critical data.


Yep, very possible.
A working sample here:

http://members.shaw.ca/glenk/access2000.html
(Look for Security & Log On Demo Database For Access2000 (Richard Rensel)

Nov 13 '05 #7

P: n/a
Jeff,

The zip file has instructions how to open the database.
Unfortunately, either the username or password have been modified since the
last time you saved it.
Please look into this and let me when it's safe to get it again.

Thanks very much,
Chuck
"Jeff Conrad" <je***@ernstbrothers.com> wrote in message
news:42**********@spool9-west.superfeed.net...
"Br@dley" wrote in message:
news:J6***************@news-server.bigpond.net.au...
Or you can make up a "pretend" security system where users login using a
simple form and user data is stored in a simple table.... not secure but
enough to fool basic users for non-critical data.
Yep, very possible.
A working sample here:

http://members.shaw.ca/glenk/access2000.html
(Look for Security & Log On Demo Database For Access2000 (Richard Rensel)

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet

News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption

=----
Nov 13 '05 #8

P: n/a
Chuck,

I did not create that file.
Someone named Richard Rensel did.
That is not my site nor my file.

What error message are you getting?

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"Chuck Insight" wrote in message:
news:Niyue.81066$x96.14902@attbi_s72...
Jeff,

The zip file has instructions how to open the database.
Unfortunately, either the username or password have been modified since the
last time you saved it.
Please look into this and let me when it's safe to get it again.

Thanks very much,
Chuck
"Jeff Conrad" <je***@ernstbrothers.com> wrote in message
news:42**********@spool9-west.superfeed.net...
"Br@dley" wrote in message:
news:J6***************@news-server.bigpond.net.au...
Or you can make up a "pretend" security system where users login using a
simple form and user data is stored in a simple table.... not secure but
enough to fool basic users for non-critical data.


Yep, very possible.
A working sample here:

http://members.shaw.ca/glenk/access2000.html
(Look for Security & Log On Demo Database For Access2000 (Richard Rensel)

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet

News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+

Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption

=----


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.