Database Role question

• karan.brar

  Newbie

  Points: 1

  More actions

  January 8, 2008 at 10:07 am

  #70688

  Database Role,

  Is there any way to find out detail info of a db role? I’m trying to find out

  all the object that are assigned or associated to a particular database role using Query analyzer. I know it’s easier to find out via EM. Thanks

  Karan.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  January 8, 2008 at 1:56 pm

  #765909

  I am afraid that you cannot find it in the Query Analyzer. SQL Server returns roles with an ID for the each user-defined role.