SqlServer 2014 - Spring Oauth2 Sql Table Script

Script per la creazione delle tabelle di Spring Security per la gestione del Oauth2 sul db di SQLServer 2014

https://gist.github.com/marcoberri/b02d5c523c0e511bdd18bda18ee5eb38

	USE [DBNAME]
	GO
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	SET ANSI_PADDING ON
	GO
	CREATE TABLE [dbo].[oauth_refresh_token](
	[token_id] [varchar](256) NULL,
	[token] [varbinary](max) NULL,
	[authentication] [varbinary](max) NULL
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
	GO
	SET ANSI_PADDING OFF
	GO
	---------------------------------------------------------
	USE [DBNAME]
	GO
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	SET ANSI_PADDING ON
	GO
	CREATE TABLE [dbo].[oauth_code](
	[code] [varchar](256) NULL,
	[authentication] [varbinary](max) NULL
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
	GO
	SET ANSI_PADDING OFF
	GO
	---------------------------------------------------------
	USE [DBNAME]
	GO
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	SET ANSI_PADDING ON
	GO
	CREATE TABLE [dbo].[oauth_client_token](
	[token_id] [varchar](256) NULL,
	[token] [varbinary](max) NULL,
	[authentication_id] [varchar](256) NOT NULL,
	[user_name] [varchar](256) NULL,
	[client_id] [varchar](256) NULL,
	PRIMARY KEY CLUSTERED
	(
	[authentication_id] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
	GO
	SET ANSI_PADDING OFF
	GO
	---------------------------------------------------------
	USE [DBNAME]
	GO
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	SET ANSI_PADDING ON
	GO
	CREATE TABLE [dbo].[oauth_client_details](
	[client_id] [varchar](256) NOT NULL,
	[resource_ids] [varchar](256) NULL,
	[client_secret] [varchar](256) NULL,
	[scope] [varchar](256) NULL,
	[authorized_grant_types] [varchar](256) NULL,
	[web_server_redirect_uri] [varchar](256) NULL,
	[authorities] [varchar](256) NULL,
	[access_token_validity] [int] NULL,
	[refresh_token_validity] [int] NULL,
	[additional_information] [varchar](4096) NULL,
	[autoapprove] [varchar](256) NULL,
	PRIMARY KEY CLUSTERED
	(
	[client_id] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	) ON [PRIMARY]
	GO
	SET ANSI_PADDING OFF
	GO
	---------------------------------------------------------
	USE [DBNAME]
	GO
	/****** Object: Table [dbo].[oauth_access_token] Script Date: 19/04/2017 08.41.06 ******/
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	SET ANSI_PADDING ON
	GO
	CREATE TABLE [dbo].[oauth_access_token](
	[token_id] [varchar](256) NULL,
	[token] [varbinary](max) NULL,
	[authentication_id] [varchar](256) NOT NULL,
	[user_name] [varchar](256) NULL,
	[client_id] [varchar](256) NULL,
	[authentication] [varbinary](max) NULL,
	[refresh_token] [varchar](256) NULL,
	PRIMARY KEY CLUSTERED
	(
	[authentication_id] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
	GO
	SET ANSI_PADDING OFF
	GO
	---------------------------------------------------------

view raw SpringSecurityoauth2SqlServer.sql hosted with ❤ by GitHub

Microservices : Spring Boot + Eureka + Zuul + OAuth2

Esempio completo della gestione a Microservices con Spring Boot e tutto il pacchetto completo  di gestione di proxy e bilanciamento. Per la gestione dell'autenticazione sempre attraverso i services di spring con Oauth2. L'esempio è basato su Jpa su Hibernate e MySql.

Trovate i sorgenti completi https://github.com/marcoberri/microservices-example

Gestione della security