Post reply

SQL permission

  • June 2, 2004 at 2:11 am

    #83005

    Hi Guru,

    Anyone can tell me what's is the usage of DRI check box in permission? 

  • June 2, 2004 at 5:38 am

    #508624

    Here is information from the BOL glossary:

    declarative referential integrity (DRI)

    FOREIGN KEY constraints defined as part of a table definition that enforce proper relationships between tables. The constraints ensure that proper actions are taken when DELETE, INSERT, and UPDATE statements remove, add, or modify primary or foreign key values. The DRI actions enforced by FOREIGN KEY constraints can be supplemented with additional referential integrity logic defined in triggers on a table.

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 2, 2004 at 5:38 am

    #508623

    Declarative referential integrity.

    Data-integrity rules that will enforce the relationships between tables and keep the database as consistent as possible


    Andy.

  • June 2, 2004 at 6:28 pm

    #508750

    Thanks a lot!

  • June 3, 2004 at 3:02 am

    #508784

    so i think you give the user the ability to make relation between tables (by making FK) .. is it right?


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • June 3, 2004 at 6:13 am

    #508807

    I believe the permission allows granted users to refer to objects which have foreign-key constraints (e.g. in a stored procedure or user defined function) vs. the ability to create relationships between table - that would would be a Create Table permission.

  • June 6, 2004 at 1:37 am

    #509143

    i think also this permission gives you the ability to write JOIN statement ... which joins the tables faster (by FK and PK)


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

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

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