Modify rights into EM

  • Hi all,

    anyone knows how can I avoid thar the users can see the users view or roles view into any database through EM?

    I don't want that they can see who has rights in the database.

    Must I deny some rights over some system stored procedure (sp_help...) to public group or something like that?

    Any comments are wellcome

    Thanks

  • If the login has no rights (are not users, nor have defined roles) to the database they cannot do anything, just see the database name ! They will also get errors every time that they open up EM on those databases that they do not have any rights to !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • I want to deny the access to the users with rights in the database. I don't want that they can see the content of the users o roles views.

    I suppose that there will be a 'procedure system' that if you unchecked the public rights then the users don't see the information into this views.

    My reasons are about security information.

    Regards

Viewing 3 posts - 1 through 2 (of 2 total)

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