Hello,
when i try to use the function "Manage user authentication and privileges" in sql server session ,i get an error. Below is the trace generated:
******************************************************************************
/* Error with snippets directory: The specified path was not found */
/* Delimiter changed to ; */
/* Connecting to ZIOBOB-PC\SQLEXPRESS via Microsoft SQL Server (named pipe, experimental), username ziobob, using password: Yes ... */
SELECT @@SPID;
/* Connected. Thread-ID: 51 */
SELECT DATEDIFF(SECOND, "login_time", CURRENT_TIMESTAMP) FROM "master"."dbo"."sysprocesses" WHERE "spid"=1;
SELECT @@VERSION;
SELECT "name" FROM "sys"."databases" ORDER BY "name";
USE "msdb";
/* Entering session "Prova SQL" */
SELECT *, SCHEMA_NAME("schema_id") AS 'schema' FROM "msdb"."sys"."objects" WHERE "type" IN ('P', 'U', 'V', 'TR', 'FN');
SHOW VARIABLES LIKE 'skip_name_resolve';
/ * SQL Error (156): Incorrect syntax near the keyword 'LIKE'. * /
********************************************************************************
System: WIN 7 64 Bit, SQL Server 9.0.5000, HeidiSQL Version 8.1.0.4563
Thanks in advance for your assistance
Error in "Manage user authentication and privileges" in sql server session
Well, the user manager is a pure MySQL functionality. I guess there is not a single query in that dialog working on MSSQL too. I did not care too much here yet, as noone complained yet, and I have zero clue how to manage users on MSSQL. I guess we have again totally different approaches compared to MySQL - not with the GRANT and REVOKE commands. But if you like you could file a bug report and give some basic hints on how users are a) created b) edited c) deleted, how privileges are named and how user names are retrieved.
Please login to leave a reply, or register at first.