hey all,
is it possible in asp.net to check what database role a user is part of?
thanks,
rodchar
6  1010 
Which version of SQL Server are you using?
rodchar wrote:
hey all,
is it possible in asp.net to check what database role a user is part of?
thanks,
rodchar
KJ,
One way is to execute a stored procedure, query the syslogins table and
return the roles.
I am not sure if there is any simpler way than this.
Regards,
Augustin http://augustinprasanna.blogspot.com
"KJ" wrote:
Which version of SQL Server are you using?
rodchar wrote:
hey all,
is it possible in asp.net to check what database role a user is part of?
thanks,
rodchar
You can also use the SQL-DMO objects available in .NET code. Check out
the IsMember method of the User class.
Augustin Prasanna wrote:
KJ,
One way is to execute a stored procedure, query the syslogins table and
return the roles.
I am not sure if there is any simpler way than this.
Regards,
Augustin
http://augustinprasanna.blogspot.com
"KJ" wrote:
Which version of SQL Server are you using?
rodchar wrote:
hey all,
>
is it possible in asp.net to check what database role a user is part of?
>
thanks,
rodchar
i'm using sql server 2000. will this work here?
"KJ" wrote:
You can also use the SQL-DMO objects available in .NET code. Check out
the IsMember method of the User class.
Augustin Prasanna wrote:
KJ,
One way is to execute a stored procedure, query the syslogins table and
return the roles.
I am not sure if there is any simpler way than this.
Regards,
Augustin
http://augustinprasanna.blogspot.com
"KJ" wrote:
Which version of SQL Server are you using?
>
rodchar wrote:
hey all,
is it possible in asp.net to check what database role a user is part of?
thanks,
rodchar
>
>
Yes.
rodchar wrote:
i'm using sql server 2000. will this work here?
"KJ" wrote:
You can also use the SQL-DMO objects available in .NET code. Check out
the IsMember method of the User class.
Augustin Prasanna wrote:
KJ,
>
One way is to execute a stored procedure, query the syslogins table and
return the roles.
>
I am not sure if there is any simpler way than this.
>
Regards,
Augustin
http://augustinprasanna.blogspot.com
>
"KJ" wrote:
>
Which version of SQL Server are you using?
rodchar wrote:
hey all,
>
is it possible in asp.net to check what database role a user is part of?
>
thanks,
rodchar
thank you all for the help.
"KJ" wrote:
Yes.
rodchar wrote:
i'm using sql server 2000. will this work here?
"KJ" wrote:
You can also use the SQL-DMO objects available in .NET code. Check out
the IsMember method of the User class.
>
Augustin Prasanna wrote:
KJ,
One way is to execute a stored procedure, query the syslogins table and
return the roles.
I am not sure if there is any simpler way than this.
Regards,
Augustin
http://augustinprasanna.blogspot.com
"KJ" wrote:
Which version of SQL Server are you using?
>
rodchar wrote:
hey all,
is it possible in asp.net to check what database role a user is part of?
thanks,
rodchar
>
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: DCount17 |
last post by:
I need to create a windows application (using C#) that creates/assigns and
retrieves database roles on Analysis Services. While I can get the users from
the "Members" table on SQL Server, I am...
|
by: MS User |
last post by:
VB.Net / SQL 2K
We are developing a VB.Net application and the question is regarding the
Login screen
We have a table which stores the access-level for each users.
Here is our requirement.
...
|
by: isideveloper |
last post by:
I'm building a new C# web application that will provide my company
some administrative operations that were previously only completed
by tweaking the data in the database.
1. Encrypted password...
|
by: AC |
last post by:
Hi there. My asp.net 2.0 development website uses roles to control
access to sections of my site, configured using the asp.net
configuration tool, which is great. Except that isn't available once...
|
by: Jeff |
last post by:
hi
asp.net 2.0
sql server 2005 (I'm using that Express version)
I have a asp.net project here which I'm wondering how to deploy the database
of. Right now I locally created a database and...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
