Bookmark and Share
Last Updates
Display: 1 - 3 of 3, Total Pages: 1
1
[Work Notes] Grant privileges and Execute queries [Original] 2014-6-4 4:00pm
--change the execution context to a specific USERGRANT SELECT ON DBschema.product to MyLogin;GOEXECUTE AS USER = 'MyLogin';GOThe following query is ok.SELECT * FROM DBschema.product;GO The follow..

Read Full Article...

Section:MS SQL Server DBA | Read:692 | Comment:0 | Rating:0%

[Work Notes] Server and database roles [Original] 2014-6-2 3:33pm
-- ADD a login to the serveradmin roleEXEC sp_addsrvrolemember mylogin, serveradmin;GO-- view the members of the server rolesuse master;GOSELECT r.name AS RoleName, p.name AS PrincipalNameFROM sys.ser..

Read Full Article...

Section:MS SQL Server DBA | Read:449 | Comment:0 | Rating:0%

[Work Notes] User accounts admin useful commands [Original] 2014-5-21 11:33am
Query the list of existing logins SELECT * FROM sys.server_principals where type IN ('S','U','G'); GO CREATE LOGIN HRApp WITH PASSWORD = 'Pa$$w0rd', CHECK POLICY = OFF; GO SELECT * FROM sys.sq..

Read Full Article...

Section:MS SQL Server DBA | Read:271 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am