facebook

Security Table setup

  1. MyEclipse IDE
  2.  > 
  3. Spring Development
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #352583 Reply

    dknutson
    Member

    In a previous post I was provided with the following description of what gets loaded in the security tables in support of the security scaffolding.

    Here is the sample data :
    Users table – (ID – 1, ENABLED – 1, PASSWORD – 1234, USERNAME – testadmin)
    Authorities table – (ID – 1, AUTHORITYNAME – ROLE_ADMIN)
    User_Authorities table – (USER_ID = 1, AUTHORITIES_ID = 1)

    Users table – (ID – 2, ENABLED – 1, PASSWORD – 1234, USERNAME – testguest)
    Authorities table – (ID – 2, AUTHORITYNAME – ROLE_GUEST)
    User_Authorities table – (USER_ID = 2, AUTHORITIES_ID = 2)

    Question: ID shown above is an integer. Why does the scaffold create the table with ID as type String?

    #352591 Reply

    dknutson,

    Question: ID shown above is an integer. Why does the scaffold create the table with ID as type String?

    Sorry for the confusion, I have just posted you all the column values. Except the ‘enabled’ column (smallint type) under Users table all the other columns are of varchar type.

    As the ID is of varchar type, the scaffold process creates the table with ID as String type.

    You can view the structure of the tables by right clicking on ‘Users’ / ‘Authorities’ / ‘User_Authorities’ table in the MyEclipse Database explorer and select Generate > DDL Statement.

    Hope this helps.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Security Table setup

You must be logged in to post in the forum log in