The process of identifying the party logging into a system.

learn more… | top users | synonyms

2
votes
2answers
328 views

How do I monitor which Windows user is logging in as SA? [duplicate]

Possible Duplicate: ProcessID Owner with third party app Several of our applications use the sa account to login to our SQL Server 2008 instance. As these applications are poorly designed ...
2
votes
2answers
131 views

remote connection

Im trying to connect to a remote sql server using windows authenication. I'm using visual studio 2012 and going to a remote sql server 2012. I have already checked in sql studio that it is set up for ...
0
votes
2answers
761 views

Secure way to connect: Windows Authentication or SQL Server Authentication and why?

Which is the best way to create a connection string for SQL Server? Should I be using a trusted connection string (windows authentication) or an untrusted connection string (sql server ...
6
votes
1answer
6k views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (MsDtsSrvr)

I have a clustered environment which has many instances in it. I have modified the xml file to allow several instances to use ssis. Everything works great when the instances are on the same node as ...
1
vote
2answers
753 views

MySQL 5.5 accepts password but then closes connection

Apologies in advance for lack of information. I have installed MySQL 5.5 x64 on a Windows XP Professional x64 development machine. Today, upon trying to connect with any tool(MySQL workbench, PHP ...
1
vote
1answer
124 views

Default Schema Problems on server

When i connect to SSMS on my server through remote desktop and query my database using: SELECT * FROM [sys].[database_principals] WHERE [principal_id] = USER_ID() I am getting the correct results ...
4
votes
1answer
148 views

Always being logged in as SA and not Windows account

First off i would like to appologise if i sound stupid as i do not have much knowladge of SQL Server. I have recently started a project working with SQL Server 2008 R2. I have access to the database ...
0
votes
1answer
570 views

Unable to reset the password of users in postgres

Evrytime i run, su - postgres it asks me for a password which I did not set. I simply installed the postgres. I have gone to the pg_hba.conf. # Database administrative login by Unix domain socket ...
1
vote
1answer
834 views

Error in login in with root user in new mysql server

I've installed a MySQL server in CentOS 6.2 machine +-------------------------+---------------------+ | Variable_name | Value | ...
5
votes
1answer
492 views

Connecting to SQL Server using cached credentials

While migrating from SQL authentication (user-password) to integrated security I ran into an unexpected combination of requirements. SQL clients are services running under a LOCALSYSTEM or ...
2
votes
3answers
4k views

Microsoft SQL Server says my login is disabled, even in single user/DAC mode

I'm locked out of a local database, and the single-user mode option that has worked for me in the past isn't working for me here. I could use some options to try. It's saying the account is disabled, ...
2
votes
1answer
131 views

Why does OS login not exist in the user table, but I can still login to MySQL?

mysql> select user, password, host from user; +------+----------+---------------------------------------------+ | user | password | host | ...
2
votes
1answer
95 views

mysqladmin user account not secure?

I still playing with my own DB trying to learn and saw this: I could change the root password without any problem at all... If I'm in the server I can create an algorithm to start testing password ...
1
vote
2answers
597 views

Secure method beside phpMyAdmin for remote mysql

Recently, one of my centos linux servers was hacked and the cause of due to phpMyAdmin. It was said due to this problem PhpMyAdmin vulnerability CVE-2011-2505 ...
1
vote
0answers
322 views

ORACLE SSL using Microsoft Certificate Store for PKI

I am trying to set up PKI SSL authentication between client and server using a Microsoft Certificate Store. Client: Windows 7 64 bit with Oracle client 11.2.0.3.0 Server: Windows 2008 R2 64 bit with ...
2
votes
1answer
89 views

Is there a restriction which prevents you from creating a user and a role with the same name?

I have a (SS2005) database with a user named MY_APPLICATION_USER. I'm trying to create a role in that database named MY_APPLICATION_USER. When I try to do that using this script: /****** Object: ...
3
votes
2answers
734 views

Is it possible to assign sql logins into a group?

This may be a bit too elementary question for this site but is it possible to control SQL Server authenticated logins using groups? So is it possible to assign sql logins under groups and give rigths ...
6
votes
2answers
953 views

securely exposing sql server 2008 for windows authentication

My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet. We have sql ...
4
votes
2answers
16k views

Grant table privileges to a user connecting from any host

I have a user account - let's call it 'wordpress' - that I need to allow to access a few catalog tables in another e-commerce database on the same server. I've configured the user with three host ...
1
vote
2answers
527 views

Mysql master-master permission replication issue

I came to know it's safe to replicate mysql database to have the users and permissions replicated, from a post in ServerFault is-it-ok-to-replicate-mysql-db. I have setup master-master replication ...
7
votes
3answers
30k views

MySQL error: Access denied for user 'a'@'localhost' (using password: YES)

I use the root account created the account 'a'@'%'. But I can't use the it to connect to MySQL server when I specify the host parameter. I can successfully connect without the -h parameter. Please see ...
8
votes
4answers
649 views

Is splitting a 'users' table for authentication purposes a good idea?

Suppose I have a user table in my site in which there are around 2-3 Million users (records) in the table. For speeding up my login process, is it a good approach to split my user table, one for ...
1
vote
1answer
90 views

mysql server password change while restoring

I restored all database backup from another server's dumpfile to my machine. At the end my mysql server's password changed to that mysql server's password. Why it got overwritten? What i need to do to ...
1
vote
2answers
724 views

Any security related reasons to prefer Windows Authentication over Sql Server Authentication?

This is a rather short question: When using Microsoft SQL Server (version 2005 and newer), are there any security related reasons to prefer Windows Authentication over SQL Server Authentication? ...
4
votes
2answers
5k views

SQL 2008 R2 creates user/schema when Windows user creates tables

We added a server login and database user that map a Windows Group to a SQL 2008 R2 instance using the following script, with the names changed for anonymity: USE master go CREATE LOGIN ...
4
votes
1answer
2k views

Windows Authentication for a non-local non-domain Login

I have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network. Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain ...
3
votes
1answer
1k views

postgres and passwordless authentication

We have users for out postgres database and none have passwords... Do not know the history behind it. When I try to use clients to connect to these databases, for instance, pgadmin III, the ...
1
vote
1answer
300 views

Grant access for any logged in user for common database

In SQL server 2008, I have one database that is a common database that is accessed thru stored procedures in all other databases. Each of the other databases have their own login. I need a way that ...
1
vote
1answer
94 views

Are there any objective reasons to prefer a prefix over a suffix for an environment-specific login?

When creating environment specific logins (development, qa, staging, production, etc.) I'm faced with the choice of making the denotation a prefix or a suffix to the login name. Examples ...
5
votes
2answers
706 views

DB2 passwords with special characters

Our DB2 authentication is integrated with active directory, so the allowed passwords are controlled by it's policy. We have some users that are not being able to connect to the database through ...
2
votes
2answers
3k views

Can a username and password be hard-coded in a system DSN

We have a legacy CRM that uses a DSN with Windows Authentication to connect to an instance of SQL Server 2005 (part of SBS 2003 Premium). We will soon be doing a major migration leaving us without a ...
2
votes
1answer
737 views

Is it possible to specify Active Directory username and password in connection string?

My organization uses Active Directory to control access to our databases. Building web applications and as part of our CI process I would like to specify the credentials in the connection string. Is ...
8
votes
3answers
5k views

Audit logins on MySQL database

Is there a way to audit logins to MySQL? I'd like to be able to create a username for each employee and thereby create an audit trail of logins. However, googling has turned up no good results. The ...
2
votes
2answers
414 views

Transferring concepts - users/groups/permissions of db objects from mysql to postgresql

This seemed like a better fit here than stackoverflow, so here goes: I've been using mysql for a while since on most of the cheap webhosts it is the provided database. However, now I've started ...
7
votes
1answer
3k views

Can I use OpenLDAP to authenticate users in Oracle?

I like to use OpenLDAP to authenticate my Oracle users. It should be possible to fetch at least the password from the directory. There appearently is something for the Oracle LDAP servers, but would ...
8
votes
3answers
1k views

MySQL LDAP authentication

Is LDAP authentication and authorization in MySQL possible? What are the requirements (MySQL version, third-party software etc.)? How it's organized? Thanks.