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

User permissions on basis of data

P: n/a
Hi all
I am working on the database bit like of auditing.
The database is simple only thing is the permissions to various
users.In the database the audit report(memo field) is issued to each
authorised person(AP) of department and he has to comment(memo) on that
perform action(memo).

It is required that when user or AP open the form he is only able to
see his
department audit report details.(bit kind of filtering the data for
that particular
person).It is also required that AP of one department is not able to
information of other department.

I am bit confused to do it as there are 10-15 departments.
Is it the normal user permissions that can work or I have to do in
different way.
There is no worry of design security or like that.
I hope I make it clear..

Dec 19 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.