Post reply

Database Roles

  • October 31, 2017 at 5:19 am

    #340253

    Hi,

    I'm having a bit of clean up on the security of our SQL Servers and I've come acrosss a number of users belonging to a role that I'm not familiar with, and cant seem to find any documentation from Microsoft one.
    The roles in question all start with 'rl_' and so I wondered if it were something to do with some old replication we once had but do not anymore, or perhaps they are just custom ones somebody created previously.

    I've attached a screen shot showing them. Also they dont seem to have any securables or owned schemas.

    If you have any idea what they are then please let me know.

    Thanks,

    Nic

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • October 31, 2017 at 8:11 am

    #1965972

    NicHopper - Tuesday, October 31, 2017 5:19 AM

    Hi,

    I'm having a bit of clean up on the security of our SQL Servers and I've come acrosss a number of users belonging to a role that I'm not familiar with, and cant seem to find any documentation from Microsoft one.
    The roles in question all start with 'rl_' and so I wondered if it were something to do with some old replication we once had but do not anymore, or perhaps they are just custom ones somebody created previously.

    I've attached a screen shot showing them. Also they dont seem to have any securables or owned schemas.

    If you have any idea what they are then please let me know.

    Thanks,

    Nic

    They aren't from any SQL Server replication - more likely user defined roles.

    Sue

  • October 31, 2017 at 8:26 am

    #1965979

    Sue_H - Tuesday, October 31, 2017 8:11 AM

    NicHopper - Tuesday, October 31, 2017 5:19 AM

    Hi,

    I'm having a bit of clean up on the security of our SQL Servers and I've come acrosss a number of users belonging to a role that I'm not familiar with, and cant seem to find any documentation from Microsoft one.
    The roles in question all start with 'rl_' and so I wondered if it were something to do with some old replication we once had but do not anymore, or perhaps they are just custom ones somebody created previously.

    I've attached a screen shot showing them. Also they dont seem to have any securables or owned schemas.

    If you have any idea what they are then please let me know.

    Thanks,

    Nic

    They aren't from any SQL Server replication - more likely user defined roles.

    Sue

    Hi Sue,

    Thanks for the reply. It certain seems that to me as well.

    I'll proceed on that basis and wait for anyone to complain on DEV before doing test and prod.

    Thanks again,

    Nic

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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