New answers tagged

4 votes

What does the term "server" mean in this context?

What does the author mean by "domain and local server user accounts The author means the OS accounts. "Local server" is an operating system instance where your SQL Server is running (...
  • 73.8k
0 votes

What's the best way of going about storing information from different groups of users?

Best depends on what the important criteria are, but your options include: What you are currently doing. Row level access control and a different database username for each company, (if your server ...
  • 2,628
-1 votes

SQL Job step run as different sql account

you can create proxy account and run as proxy account . https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/
0 votes

Run PostgreSQL without admin / superuser

Both databases offer superuser access to the person who installed them. eg postgresql's single user mode and mysql's –skip-grant-tables If you want to hide information from the user don't store it on ...
  • 2,628
-3 votes

Logon failed for login due to trigger execution

After struggling with this issue for several hours I found a very simple solution to retore the connextion to my empty local database: 1 - Open a CMD/Terminal on this path (the path may depend on your ...
  • 1

Top 50 recent answers are included