Post reply

deny users to copy database tables

  • December 4, 2015 at 2:03 am

    #313723

    Hi,

    I am using access 2007 to use forms and the tables are linked to sql server 2008 r2 express. I created a user and gave permission to database. to use the forms (using VB i am accessing the tables) so the table should be available. is it possible to deny copying data from tables!

    i don't want users to copy data, i was able to deny copy/paste of the table itself but the user still can enter the table and copy the data and get them to excel!

    please help.

    Regards,

    Rami

  • December 4, 2015 at 2:15 am

    #1843991

    Rami

    I imagine this isn't what you're looking for, but I'm finding it difficult to understand your requirement. If a user can see the data in a table, he can copy it.

    DENY SELECT ON MySchema.MyTable TO DeniedUser

    John

  • December 4, 2015 at 2:32 am

    #1843995

    Thanks,

    what i am trying to say, how to protect the data and use the forms at the same time? If i deny access to tables, then the forms will generate errors as the user don't have access to the tables.

  • December 4, 2015 at 2:40 am

    #1843998

    I don't know about forms, I'm afraid. But if you give SELECT access, the user can get to the data. Even if you secure the forms, he can still use another application to connect to the database. Have you considered an application role?

    John

  • December 4, 2015 at 2:49 am

    #1844002

    Thanks John,

    Sorry about this as i am new here. could you explain how to do a new application role (just example or idea)?

    thanks.

  • December 4, 2015 at 2:54 am

    #1844006

    Type "application role" into your favourite search engine. The first few results will probably tell you all you need to know, but if there's anything in particular that you don't understand, please post back.

    John

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply