<div>
so if a sysadmin runs it, should he/she get 105 rows back for the second query?
</div>


so if a sysadmin runs it, should he/she get 105 rows back for the second query?

<div>
No, because it will just show what he/she has permissions on and does not correspond to the db fixed roles. &nbsp;So the results will vary.<br />

</div>


No, because it will just show what he/she has permissions on and does not correspond to the db fixed roles.  So the results will vary.


<div>
OK.<br />
<br />
doesn't a sysadmin 'implicitly' have permission on 'all' that is possible in SQL Server?
</div>


OK.

doesn't a sysadmin 'implicitly' have permission on 'all' that is possible in SQL Server?

<div>
Yes, that is correct. &nbsp;There is nothing that a sysadmin cannot do on a SQL Server.
</div>


Yes, that is correct.  There is nothing that a sysadmin cannot do on a SQL Server.

<div>
OK. but sorry, I am not getting it, in that reason, should not the sysadmin have all the 105 permissions mentioned in dbfixedrolepermission sp?<br />
<br />
thanks dbaduck
</div>


OK. but sorry, I am not getting it, in that reason, should not the sysadmin have all the 105 permissions mentioned in dbfixedrolepermission sp?

thanks dbaduck

<div>
<div class="content wysiwyg-content">
are these 2 talking about the same permissions?<br />
<br />
sp_dbfixedrolepermission -- brings back 105 records<br />
SELECT * FROM fn_my_permissions (NULL, 'DATABASE') -- brings back 61 records
</div>
</div>


are these 2 talking about the same permissions?

sp_dbfixedrolepermission -- brings back 105 records
SELECT * FROM fn_my_permissions (NULL, 'DATABASE') -- brings back 61 records

DB level permissions

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.