Home Forums Notification Services Administration Assigning a select to 1 view to a user make him see all my objects?!! RE: Assigning a select to 1 view to a user make him see all my objects?!!

  • Hello

    SQL Authentication, its normal user not belong to any group its a son of SQL server only

    I've just create it in Logins in EM and assigened it to 1 view only, Acctually he can read the data from that view, but also he can browse the whole other views design, even all DTS logic and design

    How come ?!

    Try yourself

    1- add/create a user to SQL server Login and assigne him to 1 view in your dayabase

    2- register the server in other computer using EM and see how many object you can see and how namy you can browse there design ? ???!!

    I am working with Oracle Basiclly and this case is not allowed or happen in oracle EM?! I am sure i am doing a wrong thing ..

    Regards