User group permissions Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using ASPRunner.NET
Working with projects
Connecting to the database
Datasource tables, list fields, searchable fields
Choose pages
Login page
User login settings
Avanced Security Settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
Formatting options
Validation types
Lookup wizard
Events
Output directory settings
After you done
FTP upload
FrontPage Publishing
Advanced topics
ODBC
Master-details relationship
Troubleshooting "Operation must use an updateable query" errors
Connecting to database
Connecting to MS Access database
Connecting to MS SQL Server database
Connecting to MySQL database
Connecting to Oracle database
Publishing ASP.NET application to the remote Web server
Using FTP client to publish ASP.NET pages to the remote Web server
Using FrontPage to publish ASP.NET pages to the remote Web server
Events
More about events
Predefined actions
Send simple email
Send email with new data
Save new data in another table
Insert a record into another table
Check if specific record exist
Display a message on the WEB page
Redirect to another page
Custom code
Sample code
Show list of customer orders
Before deleting a record check if related record exist
Check if start date is earlier then end date
Speed up data entry using events
Frequently Asked Questions
Error: Could not load type ...
Error: Login failed for user '(null)'
Error: Login failed for user 'MACHINE_NAME\IUSR_MACHINE_NAME'
Error: Operation must use an updateable query
Error: Syntax error in UPDATE statement
Error: Syntax error in INSERT INTO statement
Error: Could not find MySQL ODBC 3.51 driver
Error: Client does not support authentication protocol
Error: Could not access CDO.Message object
How can I add new ODBC Datasource
I cannot find ODBC Administrator applet on Windows 2000 machine
I cannot connect to my Excel (Access) database
Order ASPRunner.NET online

 
  ASPRunner.NET manual


User group permissions

 

 

This feature allows to assign table level permissions on database tables and views. I.e. user A can add data into table1 and edit data in table2, user B can edit and search data in table1 and can delete data in table2 etc.

To use this feature proceed to Security step in ASPRunner.NET, click on "Advanced", click on "Define user group permissions".

On this screen, you can create user groups with assigned set of permissions. To add a new group, click "Add group". A dialog box will appear where you can choose username which defines this group and define initial set of permissions. Afterwards, you can change permissions for certain tables.

Apart from this, you can create a default group with a default set of permissions. When a user not belonging to any of specified groups is logged in, the default set of permissions mentioned above is assigned to him. For example, as shown on the screenshot above, the user not belonging to any of the groups, is able to edit and delete data, but is not able to add or search records in any table.

To delete selected group, click "Delete group."

To overwrite existing group, click "Add group" and choose the same username.

With this security model you can also use Guest account with readonly access and Admin user with full permissions on all tables. You can add more permissions to the Guest account however this is not recommended.

 

 

 

The CHM file was converted to HTML by chm2web software.