@willvin. Yes I get that. Thing is, MS SQL server is not in the dropdown as an option to choose as the database type. I was wondering if this might be the cause of the syntax issue for generating the tables in my mssql database. Also If I untick the "Apply to all Pages on Property Change", then save the changes, then open the project again, the "Apply to all Pages on Property Change" check box is ticked. Again note that the Default database is MYSQL and there is no option to change to mssql.
Also, note that under General Settings-> "System default setting" -> Default database setting. The database dropdown select box does not have mssql server as a selection, and MYSQL is the default database selection and by default the "Apply to all pages on property changes" is selected. Deselecting the "Apply to all pages on property changes" does not hold. whenever PHPrad is started this option is preselected.
So I have spent some time trying to figure out what's going on. I did a SQL trace on the authentication form. I captured the below Alter table statement. I then looked at the table and noticed that the column was not entered, no change was made to the table. I copied the query and tried to run it. It was immediately flagged with syntax errors. Please see below. Can someone look into this?
MSSQL Server
This is from PHPRAD ALTER TABLE `Users` ADD `email_status` VARCHAR(255) NULL;
This is correct. ALTER TABLE Users ADD email_status VARCHAR(255) NULL;
@willvin When I click OK after selecting page permission check boxes. I notice that the RolesPermissions data table is not updated, i.e the PermissionId, PageName and ActionName are empty, no data. I ran a trace using SQL server trace tool on the click action. I can see select statements made against the database but no table inserts are made in the RolesPermissions table also no alerts or errors are given. Any Ideas?
Thanks. I set up the dynamic role permissions tables. after selecting the role base access control user roles and tables. I clicked the OK button and got the following alert:-
"The SELECT permission was denied on the object 'UserTypes', database 'test', schema 'dbo'."
where do I go from here. I would show you screen shots of my setup but the forum alert says that the upload file is full.
Good day I have been looking to find more information that well explains the difference between static and dynamic ... roles. Can someone please explain how do they work, and in what situation would I use either?
Good day all. I am trying to connect to mssql database. My database logon is configured for "windows logon authentication" which does not require me to add a username and password when accessing the database. Under the "Select Database" section when creating a new project the application is looking for User and password. Is there a work around for this? Thanks in advance.
