How to programmatically set group/user permissions for databaseobjects?

[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.

 

[Graham Mandeno]

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]

Hi Graham,

Thanks, already found it!

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 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.