How to programmatically set group/user permissions for databaseobjects?

  • Thread starter Thread starter Sidney Linkers
  • Start date Start date
S

Sidney Linkers

Hi All,

I'm writing a patch for a backend that will create a new table and i want to
set permissions differently for some groups and users. How can i set
permissions on databaseobjects programmatically, like a table, for specific
groups and/or users?

Any advice on this would be great!

Sid.
 
Hi Sid

Have you read the Access Security FAQ? If not, then I *strongly* recommend
you go to http://support.microsoft.com/?id=207793 where you can download it
or read it on line.

It includes sample VBA code for manipulating object permissions.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
Hi Graham,

Thanks, already found it!

Sid.
Graham Mandeno said:
Hi Sid

Have you read the Access Security FAQ? If not, then I *strongly* recommend
you go to http://support.microsoft.com/?id=207793 where you can download it
or read it on line.

It includes sample VBA code for manipulating object permissions.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

Sidney Linkers said:
Hi All,

I'm writing a patch for a backend that will create a new table and i
Click to expand...
want
to
set permissions differently for some groups and users. How can i set
permissions on databaseobjects programmatically, like a table, for specific
groups and/or users?

Any advice on this would be great!

Sid.
Click to expand...
Click to expand...
 
Back
Top