I agree to Jeff. Do not use FCM but SSMS/SQL for failovers.

Seems like the script is missing following components.

1. Script out Existing roles and Permissions to each role.

2. Script out Key & Certificate Permissions

Hi James, Thanks for your contribution. Unfortunately this script cannot script out explicit permissions like ALTER/EXECUTE/VIEW DEFINITION, etc on db level.

Example: GRANT ALTER TO [user_name@mydomain.com] or GRANT EXECUTE  TO [user_name@mydomain.com]

Can...

Hello Grant, thanks for the response. Does a direct import create some kind of blocking in the database?

Can you provide a script to script out permissions for Azure SQL database, Thanks!

Hi Folks,
Any one has a script to script out user permissions from Azure SQL database? I was not able to find this in any articles/forums.
Many thanks!

Ok thanks Fred!

* High-performance Oracle source and destination by Attunity
* Fuzzy grouping and fuzzy lookup transformations

These features are only supported in Enterprise. Do you have more info on this....

Since these are dynamic ips, it won’t help that much to track the user unless you ping the system as soon as possible to find host name.

Yes, you can see the client_ip from dm_exec_connections. But I want to audit/deny the user activity from sqlcmd. Thanks!

Yeah.. they can’t remote to the server..

Good thought... if this is deleted from the server, they can utilize sqlcmd from their remote machine with -H switch??

Thanks Sue. Seems like user is using -H to spoof host name. This is something new to me. Thanks a lot! Instead of logon trigger can I make use of...