enrique_aeo
asked on
sql server 2014 - Security Enhancements - CONNECT ANY DATABASE Permission
Hi experts,
I do not understand what new:
A new server level permission. Grant CONNECT ANY DATABASE to a login that must connect to all databases that currently exist and to any new databases that might be created in future. Does not grant any permission in any database beyond connect. Combine with SELECT ALL USER SECURABLES or VIEW SERVER STATE to allow an auditing process to view all data or all database states on the instance of SQL Server.
where is the improvement? could not do with sql server 2012 or 2008?
It would be helpful for an explanation with T-SQL?
I do not understand what new:
A new server level permission. Grant CONNECT ANY DATABASE to a login that must connect to all databases that currently exist and to any new databases that might be created in future. Does not grant any permission in any database beyond connect. Combine with SELECT ALL USER SECURABLES or VIEW SERVER STATE to allow an auditing process to view all data or all database states on the instance of SQL Server.
where is the improvement? could not do with sql server 2012 or 2008?
It would be helpful for an explanation with T-SQL?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi experts
i have this error
GRANT CONNECT ANY DATABASE mylogin
My version of sqlserver is
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86)
Feb 20 2014 19:20:46
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
i have this error
GRANT CONNECT ANY DATABASE mylogin
My version of sqlserver is
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86)
Feb 20 2014 19:20:46
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
ASKER
GRANT CONNECT ANY DATABASE mylogin
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'mylogin'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'mylogin'.
If you look at my code it has the CREATE LOGIN statement so that mylogin exists.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much, and I run, but that cases could be useful this new feature?
ASKER
DBAduck - Ben Miller
why?
Which really means that the login can see the database but cannot see it's content.
why?
Which really means that the login can see the database but cannot see it's content.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER