Difference between revisions of "SQL Server 2008"

From MyWiki
Jump to: navigation, search
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Because the owner is the root of trust. It is the owner that grants, denies and revokes permission on the object<br>
 
Because the owner is the root of trust. It is the owner that grants, denies and revokes permission on the object<br>
−
http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server<br>
+
[[ Links ]]<br>
−
http://msdn.microsoft.com/en-us/library/bb669061%28v=vs.110%29.aspx<br>
+
'''logins and users''' <br>
−
http://blogs.msdn.com/b/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx    logins and users <br>
+
[[ Logins and Users in SQL Server ]] <br>
−
A login is the principal that is used to connect to the server. A user is the principal that is used to connect to a database.<br>
+
[[ Beginners SQL Server tutorial ]]<br>
−
 
+
[[ How to locate a table by table name ]] <br>
−
 
+
[[ Exam 70-461, Querying sql server 2012 ]]<br>
−
Logins are a server wide (instance level) objects. Their correct name is 'server principals' (see sys.server_principals). Server wide privileges are granted to logins, like create database or view server state permissions.
+
[[ Importing photographs ]] <br>
−
Users are a database objects, correctly referred to as 'database principals' (see sys.database_principals). They are the recipients of database permissions, like create table or select.
+
[[ Importing photographs into a table, very simple ]] <br>
−
Ordinarily a login is mapped 1-to-1 to a user in each database, via a matching SID, but there are some exception, like all members of the sysadmin fixed server role are always mapped to dbo.
+
Link - http://stackoverflow.com/questions/38533074/import-images-from-folder-into-sql-server-table<br>
−
Users without login are a specific construct for Service Broker remote identities (see Remote Service Bindings) and for code signing. You should never have to create one in any other context, and if you do, you're likely doing it wrong. Users without login are never meant to be impersonated.
+
[[ The code from above to import multiple images ]] <br>
 +
[[ to enable xp_cmdshell ]] <br>
 +
[[ Example of executing sql script by sqlcmd ]]<br>

Latest revision as of 13:13, 15 March 2017

Because the owner is the root of trust. It is the owner that grants, denies and revokes permission on the object
Links
logins and users
Logins and Users in SQL Server
Beginners SQL Server tutorial
How to locate a table by table name
Exam 70-461, Querying sql server 2012
Importing photographs
Importing photographs into a table, very simple
Link - http://stackoverflow.com/questions/38533074/import-images-from-folder-into-sql-server-table
The code from above to import multiple images
to enable xp_cmdshell
Example of executing sql script by sqlcmd

Retrieved from "https://wiki.twig.es/index.php?title=SQL_Server_2008&oldid=3678"