DBA

    技术2022-06-23  46

    DBA_TABLES describes all relational tables accessible to the DBA user

    DBA_TABLESDBA用户所拥有的或有访问权限的表

     

    ALL_TABLES describes all relational tables accessible to the current user

    ALL_TABLES是某一用户所拥有的或有访问权限的表

    USER_TABLES describes all relational tables owned by the current userUSER_TABLES是某一用户所拥有的表

     

    DBA_TABLES >= ALL_TABLES >= USER_TABLES

     

     

    DBA_ALL_TABLES Description of all object and relational tables in the database

    DBA_ALL_TABLESDBA用户所拥有的或有访问权限的对象和表

     

    ALL_ALL_TABLES Description of all object and relational tables accessible to the user

    ALL_ALL_TABLES是某一用户拥有的或有访问权限的对象和表

     

    USER_ALL_TABLES Description of all object and relational tables owned by the user's

    USER_ALL_TABLES是某一用户所拥有的对象和表

     

    DBA_ALL_TABLES >= ALL_ALL_TABLES >= USER_ALL_TABLES


    Related: http://ss64.com/orad/USER_ALL_TABLES.html


    最新回复(0)