Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    New Zealand
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    JET SQL Permissions (XP)

    Hi,
    Can anyone please give me a few concrete examples of the use of Jet SQL for setting permissions on objects other than tables as the Jet documentation is sorely lacking in this department. Tables and default settings for containers I have been successful with.
    The documentation for setting permissions on a form infers syntax something like:
    'GRANT SELECT,INSERT,DELETE,UPDATE ON OBJECT frmSuppliers TO Users' but this brings an error message of 'cannot find table of constraint' suggesting it cannot be used for forms etc.
    Further more what, if any, would be the equivalent permission for Open/Run on a report, form, macro. I imagine 'EXECUTE' would be a good bet but this is not documented.
    Also how would one differentiate between a form and a report of the same name when 'OBJECT' is the only qualifier. I realise I could resort to ADOX but I like the simplicity of building a script to set permissions.

    Any enlightenment would be appreciated.
    TIA
    Simon

  2. #2
    New Lounger
    Join Date
    Jan 2001
    Location
    New Zealand
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: JET SQL Permissions (XP)

    I have answered one small part of my own question but am still stuck on the remainder.
    To obtain an Open/Run permission on a report or form container you can grant the UPDATEIDENTITY privilege. While this seems in the wrong context it does yield the correct net effect of the Open/Run permission in DAO or Access UI.
    Still looking for any other inspiration on the rest <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Cheers
    Simon

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: JET SQL Permissions (XP)

    What exactly are you trying to do? SQL, by its nature, can only affect tables. Forms and reports are interfaces into the tables. If you want to put permissions on interface objects like forms and reports, you do it through Access security, not through SQL.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Jan 2001
    Location
    New Zealand
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: JET SQL Permissions (XP)

    Hi Charlotte,
    I am trying to use the new features in of Jet SQL introduced in Jet 4.0 that allow you to set user level security permissions in an mdb for all database objects by executing the grant and revoke sql statements.
    This article http://msdn.microsoft.com/library/default....ml/acadvsql.asp refers to the new features from the documented syntax
    GRANT {privilege[, privilege,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •