October 16, 2008 at 11:50 am
I want to find a way to find out all the users who have the 'with grant option enabled'. Also want to know how to determine whether a SQL Server has been setup to use the TCP/IP Protocol.
October 18, 2008 at 6:38 pm
There are multiple ways to find out if SQL Server is configured to use TCP/IP. In SQL2005, you can use Configuration Manager-> SQL Network Configuration->Client Protocols ->TCP/IP ( Enabled / Disabled )
Thanks,
October 18, 2008 at 10:56 pm
On SQL Server 2005/2008 you can query sys.database_permissions to see who has the WITH GRANT option. The state field is what you're looking to filter on. If the value is W that means the permission state is WITH GRANT.
As far as detecting TCP/IP as an enabled network library, Configuration Manager will do it. You can also use a scanning tool like SQLPing. However, before you do any sort of scanning, make sure you have the permission of your organization.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply