loaddata.sql

Portal Starter Kit提供了在线管理工具

            <i>Authentication</i> validates a user''s crenditials.  The Portal Starter Kit sample supports two forms of authentication.  
            
            <ul>
            <li><b>Forms-Based/Cookie authentication</b> collects a user name and password in a simple input form, then validates them against the Users table in the database.  This type of authentication is typically used for Internet and extranet portals.

            <li>With <b>Windows/NTLM authentication</b>, either the Windows SAM or Active Directory is used to store and validate all username/password credentials.  This type of authentication is typically used  for intranet-based portals.
           
            </ul>
            When you install the ASP.NET Portal Starter Kit, Forms Authentication is enabled by default.  To change the authentication mode, edit the web.config file in the root portal directory:</td>
    </tr>
    <tr>
        <td>
            <img align="left" src="data/config_auth_win.gif">
            <img align="left" src="data/config_auth_forms.gif">
        </td>
    </tr>
    <tr>
        <td class="Normal">
        
            <a name="authorization">
            <u>Roles-Based Authorization</u><br>

            <i>Authorization</i> is used to control access to the modules and tabs in the portal, including the Admin tab.  The ASP.NET Portal Starter Kit uses roles-based authorization.  The portal administrator uses these steps to set up roles-based authorization:
            
            <ol>
            <li><a href="#createrole"><b>Create a role</b></a>, for example "Managers" or "HR".
            <li><a href="#addtorole"><b>Add users to the role</b></a>, for example "CORP01\andreabr", "CORP01\tomka", and "CORP01\marklo".
            <li><a href="#tabperms"><b>Set view permission for tabs</b></a>, for example, limit viewing of the "FY01 Budget" tab to users in the "Managers" role.
            <li><a href="#editperms"><b>Set edit permission for modules</b></a>, for example, limit permission to edit information in the "HR/Benefits News" module to users in the "HR" role.
            </ol>
            
            The roles-based authorization system in the Portal Starter Kit works independently of the authentication mode.  Role membership data is stored in the portal''s configuration system, and does not rely on the ASP.NET configuration system or Windows groups.  

            <ul><li>
            <b>IMPORTANT NOTE</b>: <i>The "All Users" member is a special value that, if present, adds all authenticated users to the role.  When you first install the Portal Starter Kit, the "Admins" and "Power Users" roles contain the All Users member.  Remove this member to make the these role secure.</i>
            </li></ul>

        </td>
    </tr>
    <tr>
        <td class="Normal">
            <a name="createrole">
            <u>Creating and Managing Roles</u><br>
        
            <table cellspacing=0 cellpadding=0 border=0>
                <tr valign="top">
                    <td class="Normal" width="*">
                        The <b>Security Roles</b> section of the Admin tab lets you define roles for the portal.  
                        <ul>
                        <li>To <b>create</b> a new role to the portal, click the "Add new role" link.  
                        <li>To <b>edit</b> an existing role, click the pencil button next to the role name.  See <a href="#addtorole">Adding Users to a Role</a> below.
                        <li>To <b>delete</b> a role, click the X button next to the role name.
                        </ul>
                    </td>
                    <td>  </td>
                    <td width="320">
                        <img src="data/roles1.gif">
                        <br>
                        <img align="left" src="data/roles.gif">
                    </td>
                </tr>
           </table>    
        </td>
    </tr>
    <tr>
        <td class="Normal">
            <a name="addtorole">
            <u>Adding Users to a Role</u><br>

            <table cellspacing=0 cellpadding=0 border=0>
                <tr valign="top">
                    <td width="*" class="Normal">
                        The <b>Role Membership</b> page lets you manage the add or delete users for the selected role.<br><br>
                        
                        To open the Role Name and Membership page, select the role you wish to modify in the Security Roles section of the Admin page, then click the Change Role Members button.  See <a href="#createrole">Creating and Managing Roles</a> above.
                        <ul>
                        <li>To <b>add</b> a member to the role, select the user name from the dropdown and click the "Add to Role" link.
                        <li>To <b>delete</b> a member from the role,  click the X button to the left of the member name.
                        </ul>
                    </td>
                    <td>  </td>
                    <td width="320">
                        <img align="left" src="data/rolemembership.gif">
                    </td>
                </tr>
            </table>  

        </td>
    </tr>
    <tr>
        <td class="Normal">
        
            <a name="tabperms"></a>
            <u>Setting View Permission for a Tab</u><br>

            You can show show or hide an entire tab depending on whether a user is in an authorized role.  For example, you can limit viewing of the "FY01 Budget" tab to users in the "Managers" role. 
              
            <br><br>
            
            <table cellspacing=0 cellpadding=0 border=0>
                <tr valign="top">
                    <td width="220">
                        <img src="data/layout.gif">
                    </td>
                    <td>  </td>
                    <td width="*" class="Normal">
                        <ul>
                        <li>To set which security roles may view a tab, go to the <a href="#workmodules">Tab Name and Layout</a> page for the tab.  Check the desired roles in the "Authorized Roles" section, then click the "Save Tab Changes" button.
                        </ul>
                    </td>
                </tr>
            </table>  

        </td>
    </tr>
    <tr>
        <td class="Normal">
        
            <a name="editperms"></a>
            <u>Setting Edit Access for a Module</u><br>

            Permission to edit module data is granted by security role on a per-module basis.  
            
            <ul>
            <li>To set the roles that may edit data for a specific module, go to the <a href="#modulesettings">Module Settings</a> page for the module.  Check the desired roles in the "Roles that can edit content" section, then click the "Apply Module Changes" button.
            </ul>
            
            <table cellspacing=0 cellpadding=0 border=0>
                <tr valign="top">
                    <td width="220">
                        <img src="data/modulesettings.gif">
                    </td>
                    <td>  </td>
                    <td width="*" class="Normal">
                    
                        Normally, a module''s Edit button is shown only to users who have permission to edit the module''s data.  If you wish, however, you can show the Edit button to all users.  When an unauthorized user clicks the Edit button she recieves an "Edit Access Denied" message, which prompts her to contact the portal administrator to set up edit access.   
                        
                        <ul>
                        <li>This is a portal-wide setting.  To show the Edit button to all users -- even those who do not have edit access -- go to the <b>Site Settings</b> section on the main Admin page and check the "Always show Edit button" checkbox, then click the "Apply  Changes" button.
                        </ul>
                    </td>
                </tr>
            </table>  

        </td>
    </tr>
</table>','','')

GO

DECLARE @fmt nvarchar(3)
SELECT @fmt = dateformat FROM master..syslanguages WHERE name = @@Language
SET DATEFORMAT @fmt
GO

--
-- End load data
--