Sql

Search

how to delete user sql server

USE master ;
GO
REVOKE CONNECT SQL FROM ApplicationSQLUser2  AS ApplicationSQLUser1;
GO
GRANT CONNECT SQL TO ApplicationSQLUser2 AS SA;
GO
ALTER AUTHORIZATION ON SERVER ROLE::[ServerRoleOwnedByUser1] TO [sa] ;
GO
ALTER AUTHORIZATION ON DATABASE::Db2 TO sa;
GO
DROP LOGIN [ApplicationSQLUser1];
GO

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql show foreign keys column
Sql :: mysql last friday of current month
Sql :: rebuild index sql server
Sql :: how to relationship query two different tables in MySQL
Sql :: mssql describe stored procedure sqlcmd
Sql :: SQL Find text in SPs
Sql :: how to execute MySQL Stored Procedure in Python
Sql :: full outer join postgres
Sql :: nested select sql
Sql :: How to check if a column exists in a SQL Server table?
Sql :: mysql filter by date mount
Sql :: sql limit to 5 results
Sql :: mysql date_format
Sql :: else if sql
Sql :: sql vs nosql
Sql :: first max salary in sql
Sql :: plpgsql coalesce equivalent for empty string
Sql :: sql select like
Sql :: view acl table oracle
Sql :: how to check common records in 2 table
Sql :: get comma separated values in mysql with group by
Sql :: order by with where clause in mysql
Sql :: Write an SQL query to fetch the count of employees working in the department ‘Admin’.
Sql :: creating tables in sql with python
Sql :: sql alternative to max statement
Sql :: sql server get date of previous sunday
Sql :: SQL Server date literal
Sql :: mysql copy row with new id
Sql :: insert into table sql
Sql :: mysql preg replace

Search

SQL

how to delete user sql server

ADD CONTENT