Tag Info

New answers tagged

0

If you are simply trying to suppress the error message # WARNING: Using a password on the command line interface can be insecure. just redirect stderr to NUL (the Windows equivalent of /dev/null in Linux) mysqldiff.exe --server1=root:password@localhost:3306 --server2=root:password@localhost:3306 db1:db2 2>NUL If you want to collect errors to a text ...


0

You can put the password in the my.cnf (or my.ini for Windows) and then login without specifying the password "over the wire". Obviously you want to keep that file secure, but in any decent setup, this should not be a problem. LOGGING IN [pol@localhost inst]$ ./bin/mysql --defaults-file=./my.cnf -S ./mysql.sock -u root -- **NOTE: no password is needed ...


2

There is no way that you are going to get this 100% accurate. Though you can use PWDCOMPARE to check against a list of weak passwords (you can add to the list of weak passwords and do a comparison). I have written a similar script that does the comparison and gives you the results. I have posted it on github.


7

This may not be popular among your users, but I believe the only way you can know for sure is to force a password change for every SQL login with CHECK_POLICY = ON. This will generate a set of ALTER LOGIN commands with blank passwords, you can update the query giving them all a common password or manually update each one with individual passwords - just make ...


0

Password Policy per SQL Login is only a flag for on or off. If the Password Policy flag is checked, then the Windows Password Policy from the operating system are enforced. Check the CREATE LOGIN documentation for the details on what happens when CHECK_POLICY and CHECK_EXPIRATION are set. You can see the settings per SQL user by checking columns ...


-1

please check user rights for that drive. May be problem is with access rights for particular drive. Give full rights for that drive with 'everyone' user. Your problem will sort out. Restart Sql server instance and check database status, your recovery pending error is solved. Thanks


0

Yes, you will need Oracle Advanced Security to be installed. See http://docs.oracle.com/cd/E25054_01/network.1111/e10746/asointro.htm#i1008433 However a license for Oracle Advanced Security is no longer needed with 11g Release 2, but you will apparently need a license for "Oracle Identity Management Directory Services Plus". See PDF page 10 of ...


1

I faced the same problem and at first, I solved the problem by turning on the TRUSTWORTHY property on the database. But, I find it not a safe way in terms of security. The best practice to tackle this problem is by going to the job steps "-->Advanced-->" make it blank under "Run as user". When you provide a login account under "Run as user", you are telling ...


1

SQL Server never automatically disables any account. Only a human intervention can do that.... Probably you could put a request for your DBA to provide error logs for the timings you wanted....and you could find the info from the logs....


2

I found a solution involving a few extra steps. The "tenant_admin" role is still created the same way, but it is now used as follow: postgres=> SET ROLE tenant_admin; SET postgres=> CREATE ROLE "owner3"; CREATE ROLE postgres=> GRANT ...



Top 50 recent answers are included