Hi all,
I have an webapplication and I want to let the app check the privileges of the user logged in. with that info the app must show some functions of the system and hide others.
I want to know if somenthing like this is possible and how I can do It
PS.
MySQL has a table with users, tables and the privileges those users had on that table and you could just use a select statement to shwo them.
(Is something like this also possible in SQL server 2k)
thnx in advanceEY guys, a big part of my app is this security issue.
If someone knows if this is possible and how to do this or any kind of information, plz tell me.
if you think I want to do something impossible tell me also then I can resign from this assignment ;)|||Hi,
I need some help with logical thinking.
I can retrieve the permissions allowed to a user or role. but if I grant a role an action let's say delete and grant an user to that role I can't retrieve the permission to delete for that user.
What I want to do is to use an own Sproc and sp_helprotect and sp_helpuser to put the retrieved permissions in a table and check the members of a particilar role. then I want to let the aplication get the retrieved information from that table.
because I can't get the output value of a sproc in my application (asp.net), I think this is the best option.
But I don't know if this is wise or not to do like this.
So I ask if somebody knows a better way.
PS.The only thing I can get from the sproc to my app is the Rows affected and the result of a select query
Showing posts with label app. Show all posts
Showing posts with label app. Show all posts
Tuesday, March 27, 2012
Monday, March 19, 2012
check file date script
SQL Server file system objects
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
Regards
Hi steve,
I will recommend the .NET framework for your application and SQL Job Agent
for your monitoring purposes.
Regards,
Jon
|||Look in "Books on Line" (BOL) that comes with SQL Server as it is a great
resource for SQL Server questions of all types.
Using T-SQL you can read values out of an XML doc and compare them to
variables in a stored proc. Look in BOL and if you have any more questions
feel free to ask.
"Steve T." wrote:
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field in
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the database.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed from
> the Exchange table.
> Having no background in programming languages and fairly new to
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
>
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
Regards
Hi steve,
I will recommend the .NET framework for your application and SQL Job Agent
for your monitoring purposes.
Regards,
Jon
|||Look in "Books on Line" (BOL) that comes with SQL Server as it is a great
resource for SQL Server questions of all types.
Using T-SQL you can read values out of an XML doc and compare them to
variables in a stored proc. Look in BOL and if you have any more questions
feel free to ask.
"Steve T." wrote:
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field in
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the database.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed from
> the Exchange table.
> Having no background in programming languages and fairly new to
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
>
check file date script
SQL Server file system objects
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database
.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
RegardsHi steve,
I will recommend the .NET framework for your application and SQL Job Agent
for your monitoring purposes.
Regards,
Jon|||Look in "Books on Line" (BOL) that comes with SQL Server as it is a great
resource for SQL Server questions of all types.
Using T-SQL you can read values out of an XML doc and compare them to
variables in a stored proc. Look in BOL and if you have any more questions
feel free to ask.
"Steve T." wrote:
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made
,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field i
n
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the databa
se.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed fr
om
> the Exchange table.
> Having no background in programming languages and fairly new t
o
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
>
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database
.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
RegardsHi steve,
I will recommend the .NET framework for your application and SQL Job Agent
for your monitoring purposes.
Regards,
Jon|||Look in "Books on Line" (BOL) that comes with SQL Server as it is a great
resource for SQL Server questions of all types.
Using T-SQL you can read values out of an XML doc and compare them to
variables in a stored proc. Look in BOL and if you have any more questions
feel free to ask.
"Steve T." wrote:
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made
,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field i
n
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the databa
se.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed fr
om
> the Exchange table.
> Having no background in programming languages and fairly new t
o
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
>
check file date script
SQL Server file system objects
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
RegardsHi steve,
I will recommend the .NET framework for your application and SQL Job Agent
for your monitoring purposes.
Regards,
Jon|||Look in "Books on Line" (BOL) that comes with SQL Server as it is a great
resource for SQL Server questions of all types.
Using T-SQL you can read values out of an XML doc and compare them to
variables in a stored proc. Look in BOL and if you have any more questions
feel free to ask.
"Steve T." wrote:
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field in
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the database.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed from
> the Exchange table.
> Having no background in programming languages and fairly new to
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
>
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
RegardsHi steve,
I will recommend the .NET framework for your application and SQL Job Agent
for your monitoring purposes.
Regards,
Jon|||Look in "Books on Line" (BOL) that comes with SQL Server as it is a great
resource for SQL Server questions of all types.
Using T-SQL you can read values out of an XML doc and compare them to
variables in a stored proc. Look in BOL and if you have any more questions
feel free to ask.
"Steve T." wrote:
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field in
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the database.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed from
> the Exchange table.
> Having no background in programming languages and fairly new to
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
>
check file date
SQL Server file system objects
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
Regards
I would recommend that you start with the SQL Server documentation (aka
Books OnLine) and the XML chapter there.
HTH
Michael
"Steve T." <stornari@.nvrinc.com> wrote in message
news:O$y%23aFjhEHA.712@.tk2msftngp13.phx.gbl...
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field
> in
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the database.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed
> from
> the Exchange table.
> Having no background in programming languages and fairly new to
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
Posted: 08-18-2004 06:23 PM
Hello World!...
Here is the scenerio..
SQL Server Database
VB FrontEnd App.
App loads XML file data into database.
Changes are often made to the XML files. When changes are made,
the files must be reloaded into the database via the application. Changes
have been missed causing loss of production and jobs being processed
incorrectly.
I am looking for a script that will check the filedate of the
xml file or the filedate tag in the xml against a 'DesignFileDate' field in
the database. If a discrepancy in the filedates is identified, I want to
load the XML data to a temporary table [ExchangeTable] into the database.
The developer will provide a process to either load the data
into the production database or delete the data. This will be processed from
the Exchange table.
Having no background in programming languages and fairly new to
SQL this is quite a challenge.
Any assistance is greatly appreciated..
Regards
I would recommend that you start with the SQL Server documentation (aka
Books OnLine) and the XML chapter there.
HTH
Michael
"Steve T." <stornari@.nvrinc.com> wrote in message
news:O$y%23aFjhEHA.712@.tk2msftngp13.phx.gbl...
> SQL Server file system objects
> Posted: 08-18-2004 06:23 PM
> Hello World!...
> Here is the scenerio..
> SQL Server Database
> VB FrontEnd App.
> App loads XML file data into database.
> Changes are often made to the XML files. When changes are made,
> the files must be reloaded into the database via the application. Changes
> have been missed causing loss of production and jobs being processed
> incorrectly.
> I am looking for a script that will check the filedate of the
> xml file or the filedate tag in the xml against a 'DesignFileDate' field
> in
> the database. If a discrepancy in the filedates is identified, I want to
> load the XML data to a temporary table [ExchangeTable] into the database.
> The developer will provide a process to either load the data
> into the production database or delete the data. This will be processed
> from
> the Exchange table.
> Having no background in programming languages and fairly new to
> SQL this is quite a challenge.
> Any assistance is greatly appreciated..
> Regards
>
>
Subscribe to:
Comments (Atom)