The User's Select Query Should Be Denied But It Didn't?
Nov 24, 2006
hi ..
my problem is
i create a user in sqlserver from enterprise manager as follows:-
1- goto logins and new login
2-type a name and choose sqlserver authentication and type a password
3- from server roles tab i choose system administrators
4 from database access i choose the database i need that user to connect to .and OK
5-i goto database node in enterprise manager and select the database and the table
and double click on it and choose permissions and de-select the SELECT privilige
then i use ADO to connect to sqlserver through that user and when i select(SQL query) the table the data appeared normally !!!! and it suppose to give me exception
thanks in advance.
View 6 Replies
ADVERTISEMENT
Mar 9, 2006
I have 1 table:
ID pagename datevisited
1default01/01/2006
1info01/01/2006
1default02/01/2006
1info02/01/2006
1summary02/01/2006
2default02/01/2006
2info02/01/2006
2summary02/01/2006
I need to run query for ID who didn't visited a summary page(per day)
How do I do this?
View 1 Replies
View Related
Jul 17, 2006
In one query, I would like to query every user table in a specified database for
SELECT TOP (3) COUNT_BIG([Event Count]) AS EventNum, [Target IP], MAX([Time]) as LastSeen
GROUP BY [Target IP]
ORDER BY EventNum DESC
How is this possible?
Please give examples, I am a beginner.
Assume every table has the same structure for columns event count, target ip, and time.
View 3 Replies
View Related
Aug 8, 2007
Hi All!!
I have recently come across the following problem when attempting to access the solution file for the project in question. I double click to access the file and VS2003 fires up, only for it to give me the above warning. At which point nothing is loaded in the tree!
When I check things out they do show up in Source Safe but if I need to add any new reports (which I do), I am unable to add them...
Cany anyone shed any light on the matter?
Thanks a million!!
View 2 Replies
View Related
Jan 14, 2005
Hi!
I've just started to learn to use Visual Studio, and has come to database access.
I ran into this errormessage:
access denied for user <machine name>ASPNET
The book I'm using just only say that I have to grant the ASPNET user account permissions before the Web application will have access to a SQL database. ... Seems clear at first glance ... but I lack a "how to" ...!
---
I've tried to search the net for solutions ... several thousands of pages came up ... indicating that I'm far from the first who have this problem. ... So after I now have spend hours reading, without finding any useful ansver to the question. ...
So let me just tell the most popular answers. (So You don't repeat something I allready have read hundreds of times.):
This question has been asked before
Yes, true answer, but it doesn't help.
See the FAQ
If it was stated were in the FAQ to look it could have been useful.
Use something called "enterprise manager" (WIN XP pro, don't have this, though.)
I use WIN XP pro, so that answer dosn't help me either.
---
Hope some one can help.
View 4 Replies
View Related
Aug 23, 2007
Hi,
I'm fairly new to dbases and inherited and app that logs data to a MSSQL dbase in one of the data centers. The setup is this:
PC running XP with a valid ODBC entry in the 'System DSN' to the database.
Database machine is Windows Server 2003, MSSQL 2000
What happens:
This error is thrown:
Runtime error (80040e09):
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'gav', database 'MY_DBASE', owner 'dbo'.
Sequence of events:
I log into the machine as a user that is defined in the dbase 'User'
When I run the program, this is executed when the program starts:
gconQA.Execute "EXEC sp_setapprole 'AppRole1', 'pwF'
Program launches and runs till I want to navigate to a form that uses a table called 'gav' and the error above is tossed.
So I proceed to use Enterprise Manager, from another machine, and look in the 'Roles' section of the dbase, I see a 'AppRole' defined with a type "Application", if I click on this to see the properties for this role, I see the 'Application role' option button selected and greyed out along with the password text box with a password in the box, looks good I guess.
If I click on the 'Permissions' button, this role has 'Select', 'insert', 'update' and 'delete' rights on all the tables we created in the database(to log our data in) including the 'gav' table in the error. This all looks good.
Okay, so I suspect it may be related to the 'User's defined so I go to the 'User' section of the dbase. I see several listed including one for the machine I'm using to connect to the dbase. When open the Properties for this user, two 'role membership' checkboxes are selected, 'db_public' and 'db_datawriter'. Finally, if I click on the 'Permissions' button for both memberships I see that NONE of the check-boxes are selected for either the 'db_public' or the 'db_datawriter'. No 'Select', 'insert', 'update' or 'delete' rights at all for this user it seems. So I think I onto something here.
Can you help me here, what has higher precedence for dbase rights/access. Pointing me to a MSDN link would be GREAT if I'm on the right path here. If not, please steer my in the right direction and if you need more info, let me know.
thanks,
tim
View 1 Replies
View Related
Mar 26, 2005
Hello guys,
Been trying out to use SQL server, so got a copy of SQL Server 2000 on windows xp pro, rather old it seems but the only version I can get my hands on.
However, I just couldn't get it to work in a simple datagrid. The error message:
SELECT permission denied on object 'classList', database 'ck', owner 'dbo'.
Code on asp.net page:
SqlConnection1.Open()
DataGrid1.DataSource = SqlCommand1.ExecuteReader
DataGrid1.DataBind() 'Put user code to initialize the page here
SqlConnection1.Close()
Dim a As SqlCommand
a.ExecuteReader()
I have already added a localhost server (windows NT) under SQL server group, added localhost/ASPNETas a user for my imported database from access, granted SELECT Permission to the database and all tables, any idea what may be wrong with my configuration. I know it's pretty hard to pinpoint the exact problem since it's on my computer, but I have been clicking around and allowing everything on SQL for a few hours, but nothing good. So please any suggestions? Thanx
View 2 Replies
View Related
Mar 22, 2001
Does any body have this problem? when I execut the store procedure in database A that select from a table in database B. I got error
message "SELECT permission denied on object", I know that if I have the permission to execute the store procedure, I don't need the select permission to table. Is is a bug in SQL 7.0 version or what? In SQL 6.5, as long as we have execute permission to Store procedure it will work.
View 3 Replies
View Related
Feb 15, 2000
Why would we get the error 229 Select Permission on object denied when the user has select permissions granted? All tables in the database are accessible by the user but this one. All tables for this user have the same permissions: Select, Insert & update.
I noticed that the indexes were not set up correctly but even after fixing them it didn't help. what other reasons would cause this error.
This is an Access 97 database linked to SS7.
thanks
View 1 Replies
View Related
Apr 27, 2009
I am trying to set up a DotNetNuke installation on Windows XP with IIS 5.1 and MSSQL Server Express 2008. I have checked the permissions on the account trying to access the database and everything is checked. However I keept getting the error, do I need to make ever user in the database an admin to edit and do everything to the database?
Code is Below:
Code:
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 229
Message: The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
[code]...
View 2 Replies
View Related
Nov 19, 2006
I've been scouring the 'Net and I'm surprised to not find any info on this. Apparently I've screwed up something that nobody else has managed to screw up.
Using Win03EE and SQL2005.
I created the ASPState database using "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Aspnet_regsql.exe" using "-sstype p" to put the data in ASPState instead of tempdb.
During the creation I used an admin SQL login (let's call it "MyAdmin") that has full admin permissions. (MyAdmin is a SQL login, not a domain account.) I then created an "ASPState" SQL login (not domain) and gave it full permissions within the ASPState database.
I should probably note that the Win03EE server is also a domain controller even though the SQL logins I'm using are non-domain. This is because, currently, the development workstations are not part of the server's domain. Since the entire environment is strictly for research and development, optimum security is not the first concern at this point.
When I run the ASP.NET 2.0 web application with the connection string set to use the MyAdmin account, everything works fine. I can even poke around in ASPState with SSMS and see the session entries being inserted in the tables.
When I run the application with the connection string set to use the "ASPState" login, I get "SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'".
If I give ASPState sysadmin priviledges, it works. Of course, I don't want to give ASPState sysadmin priviledges.
I have seen non-ASPState issues posted on the 'Net involving permission denied and mssqlsystemresource. From those I've come to understand that this likely has to do with the changes made to SQL2005 that are probably not anticipated by the current version of aspnet_reqsql.
So... can anyone help me save what's left of my hair from being pulled out any further? I've been clicking various permission settings on and off all day long with no results. The lack of correlation between mssqlsystemresource and what permission setting is needed where is pretty frustrating.
In addition to the solution to this problem, I'd really appreciate any info anyone has on a great place to go read about security setting adjustment considerations in light of the changes made in SQL2005. In particular, what changes from SQL2000 to SQL2005 impact the operation of existing SQL2000 code and what an admin should know about adjusting security settings.
Thanks!
View 1 Replies
View Related
Feb 7, 2006
Hi,
I'm trying to upgrade my SQL 2000 to 2005 and use it with a web site. I've copied the DB from a SQL 2000 server machine to a 2005 machine, attached the DB to the SQL server using the relative function in Management Studio, but I still continue to get the same error:
[Microsoft][SQL Native Client][SQL Server]SELECT permission denied on object 'Users', database 'YouPlayIt', schema 'dbo'.
using this query: SELECT UserId FROM USERS.
Querying the DB from an ASP page with the query "SELECT CURRENT_USER", the system return the expected value: NKNLEPETD0IUSR_NKNLEPETD0
In SQL server, I've created a user with this name (taking it from the users list), and granted full access to all the tables of the DB.
In the permission Tab of the USERS table the NKNLEPETD0IUSR_NKNLEPETD0 have all the grant checked.
Which other permission do I have to specify in order to have access to the data ???
Thank you,
Nicola Lepetit.
www.youplay.it
View 25 Replies
View Related
Oct 30, 2006
I am using VB 2005 express edition with sql express 2005. I did it this little application that select data from a table. Everything Ok on local but if I use it over lan (it is a workgroup) I obtain this error:
SELECT permission denied on object 'Consensi' on database 'C:dbmarcoplate_dati.mdf' with schema 'dbo'
I used SQL Server Management Studio Express to give all permissions to the user for the Plate_Dati database but nothing changed
this is the program:
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Stringa As String = "Data Source=TAPFWSQLEXPRESS;Initial Catalog=c:dbmarcoplate_dati.mdf;
Integrated Security=SSPI;"
Dim cnn1 As New System.Data.SqlClient.SqlConnection(Stringa)
Try
cnn1.Open()
MessageBox.Show("Connection opened")
Dim sqlQuery As String = "SELECT Targa FROM Consensi WHERE Targa = 'AJ385SW'"
Dim cmd1 As New SqlCommand(sqlQuery, cnn1
Dim rdr1 As SqlDataReader
rdr1 = cmd1.ExecuteReader()
Try
Do While rdr1.Read()
MessageBox.Show(rdr1.GetString(0))
Loop
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
rdr1.Close()
End Try
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
MessageBox.Show("Connection closed")
End Try
End Sub
End Class
Please help me I don't know what to do
Thank You
View 4 Replies
View Related
Jun 22, 2006
Hello all,
I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error -
Server Error in '/phonebook' Application.
SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.
Error occurs at - reader = cmd.ExecuteReader();
The stacktrace looks like this -[SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742 System.Data.SqlClient.SqlCommand.ExecuteReader() +42 Phonebook.ResultPage.CreateDataSource() in c:inetpubwwwrootphonebook
esultpage.aspx.cs:56 Phonebook.ResultPage.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootphonebook
esultpage.aspx.cs:39 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
I have tried managing permissions both on IIS as well as Enterprise Manager and given all rights to the admin. Please help me out
Thanks
Sanchita
View 10 Replies
View Related
Sep 15, 2014
I have a user, who is trying log into the server, but everytime he gets this error saying something about the Group policy denies him access.
This user needs access and i'm trying to understand how to grant it to him.
I have been looking into how i can access the group policy editor, but the farthest i can get is the Local group policy editor. How do i make sure this specific user has access?
View 1 Replies
View Related
Mar 28, 2007
Hi all,
I know this error (below) has been presented before, but I have tried the typical solutions without any luck. The solutions I have tried involve insuring cross-database ownership is enabled. We have run the following query, without any luck with fixing the error.
Is it possible we have something wrong with the tempdb, or modeldb? All the settings appear to be normal (dbo public access). Any ideas would be appreciative.
Thanks,
Oun
To reconfigure SQL 2000 SP3 for ASP.net session state you must runuse master
go
EXEC sp_configure 'Cross DB Ownership Chaining', '0';
RECONFIGURE
GO
View 4 Replies
View Related
Oct 12, 2007
Hi all,
I have my asp.net application with crystal reports which is using OLE DB connection , when I published the application on my test server every thing was ok and I was able to view,print and exprot my reprot (test server is not a domain controller), BUT when I published the application on the production server which is a domain controller it is giving me this error:
Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: The SELECT permission was denied on the object 'MyTable', database 'MyDatabase', schema 'dbo'. SQL State: 42000 Native Error: Failed to open a rowset. Error in File C:WINDOWSTEMPMyreport {C4BCF4E0-469D-4425-8556-A3D2A17059B8}.rpt: Failed to open a rowset
I tried to give the IIS user all the permisions on the database, no result
I tried also to make the authentication mode in IIS to Integrated windows authentication (Disable the user IISER_---) but it still give me the same error
Please help, any help will be highly appreciated
View 7 Replies
View Related
Jul 10, 2004
First off - complete newbie using MSDN.
Getting the error message
System.Data.SqlClient.SqlException: SELECT permission denied on object 'mytable', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteReader...
1. After a lot of googling I've done the following:
EXEC sp_grantlogin 'MYMACHINEASPNET' to grant the ASPNET logon access to the DB
2. Changed the
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode
to 2 to allow mixed mode.
3. using my connection string in web.config - have experimented with different strings with/without trusted_connection and the sa uname and pwd.
(Current connection string is
"server=localhost;Integrated Security=SSPI;Database=master;Data Source=MYCOMPUTERNAME;trusted_Connection=yes"
I'm NOT using SQL Server so what commands do i need to give my db/table SELECT permissions? (and who am I giving permission to - very confused)
I had no bother accessing the server and DB from a simple C# command line program.
Been pulling my hair out for many hours now... any help would be greatly appreciated!
View 1 Replies
View Related
Jul 10, 2004
(Not having a great day - didn't mean to lock that last post - apologies)
First off - complete newbie using MSDN.
Getting the error message
System.Data.SqlClient.SqlException: SELECT permission denied on object 'mytable', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteReader...
1. After a lot of googling I've done the following:
EXEC sp_grantlogin 'MYMACHINEASPNET' to grant the ASPNET logon access to the DB
2. Changed the
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerLoginMode
to 2 to allow mixed mode.
3. using my connection string in web.config - have experimented with different strings with/without trusted_connection and the sa uname and pwd.
(Current connection string is
"server=localhost;Integrated Security=SSPI;Database=master;Data Source=MYCOMPUTERNAME;trusted_Connection=yes"
I'm NOT using SQL Server so what commands do i need to give my db/table SELECT permissions? (and who am I giving permission to - very confused)
I had no bother accessing the server and DB from a simple C# command line program.
Been pulling my hair out for many hours now... any help would be greatly appreciated!
View 5 Replies
View Related
Mar 9, 2005
Hello
My hosting company created a database for me a few day ago.
To make queries into a database,I made aspx page with textarea for query text and two radio buttons for select/insert.
I can create a table but if i make a SELECT or INSERT statement I get permission denied error.In that error database and owner data are the same as my database and user ID I use in a connection string.
So why dont I have permissions?
I created an account in webmatrixhosting to test my application and there everything works just fine.
So I tried to use "sp_tables" query before I make any table.
On my hosting company I got nothing but in webmatrixhosting
I get 16 rows of SYSTEM_TABLES and 2 rows of VIEWS.
Did my hosting company correctly set up my database?
They say they did but I Im not so sure.
Please Help
Thank You
Greeting from Slovenia
Daniel
View 3 Replies
View Related
Feb 11, 2008
A client has the following SQL Server 2005 error. The user is unable to log into Management studio. We deleted the user and login and re-created the user and login and get the same error. FYI: If the user is given db_owner and all login privs except sysadmin he gets the error. Only syslogin grants him access. It looks like he is denied access to sys.configurations via the new resource database. Any thought?
The error:
Cannot get to <instance name>.
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The SELECT perrmission was denied on the object 'configurations", database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
View 3 Replies
View Related
Nov 17, 2005
We have a web app that accesses Sql Server 2000 using windows authentication. We recently installed SQL Server 2005 on a new server and are in the process of porting the data from SS2000 over to 2005. I expected some problems, but I've run into something that seems like it should be relatively simple to solve, yet I have been banging my head against the wall for a couple of days. After changing the connection string in web.config of the web app to point to the new SQL Server 2005 database, I keep getting ... SELECT permission denied on object 'tUser', database 'GDoc', schema 'dbo'. The problem is, when I go into Management Studio and check the permissions, the user I'm logged in as DOES have select permissions on that database. What am I not doing? Am I forgetting something simple?
View 4 Replies
View Related
Mar 12, 2007
I am running a C# asp.met application which most of the application is running ok but several of my aspx. pages are giving me this error. I am currentyly running MS-SQL 2005 Dev ed. using VS.net 2005. I have turned on access in role to everything and still am getting this error. can someone help me please?
View 1 Replies
View Related
Apr 15, 2008
hay there...i'm developing a website using visual studio 2005, when i run it from VS it works fine and it can access the DB.but when i make an alias and run it directly from localhost ..i keep getting this message when i try to fill a DATASET ..Line 198: cmd.CommandText = "Select Line From Buses";Line 199: da.SelectCommand = cmd; Line 200: da.Fill(ds);can anyone help me ?thanx
View 10 Replies
View Related
Apr 9, 2007
Hi all,
I was wondering whether there is a way to show the user an error when the user did not select a specific parameter.
In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ?
Thanks
Bernard
View 4 Replies
View Related
Sep 27, 2007
Hi,
I granted all the rights on the database to the user (db_owner, public, db_datawriter, etc...) However, I didn't grant the "System Administrators" role. I also specifically granted the select on those tables (sysobjects and sysindexes) for the user and checked through ‘sp_helprotect sysobjects’ command whether there are no specific revokes for for that user.
However, the user is still getting the below error while trying to expand the "Tables" view in the Enterprise Manager.
ERROR 229: SELECT permission denied on object 'sysobjects', database 'My_test', owner 'dbo', SELECT permission denied on object 'sysindexes', database 'My_test', owner 'dbo'.
Also, the user claims that he can’t seem to do anything with the database, he can’t view any objects, and, when he goes to Query Analyzer, if he tries to run a SELECT query on a table (that he know that this table exists), he gets this error:
SELECT permission denied on object 'tblBillingTrans', database 'My_Test', owner 'dbo'.
Any help would be greatly appreciated!
Thanks,
Alla
View 7 Replies
View Related
Nov 12, 2007
Hi,
I have a select statement running on the client machine linking to different tables in 1 database. All with the same schema. When I ran it, i had this error. I had trial and error, removing 1 table at a time until i hit the one which is causing it. when i removed it, everything's ok. i just wonder if all the tables were using dbo schema what is causing this particular table to throw this error?
cherriesh
View 1 Replies
View Related
Nov 9, 2007
Hi,
I'm in need of a few more pointers when it comes to SQL Server 2005 Security setup for accessing a database through IIS web services. There's loads of great advise in these forums which I've followed so pls forgive me if I've missed a post that finally resolves this. I know I'm so close but it feels so very far...
Anyhow, here's the set up:
- Server 2003 / SQL Server 2005 / .NET 2.0 / Visual Studio 2005 / Client XP PC
The story so far:
- Built an ASPX website in VS2005 on a client PC that connects to a SQL2005 db. No probs during development.
- Copied website to WS2005 & configured IIS accordingly. No probs browsing non-db webpages.
The problem:
As soon as I browse to a page that extracts data from the db I get the following error message..
[SqlException (0x80131904): The SELECT permission was denied on the object 'tbl_location', database 'SmartDMA', schema 'dbo'.]
...plus a whole load of code that I've seen plastered over lots of forums.
My configurations:
- The website is in the default SQL Application Pool that has the identity set to 'Predifed: Network Service' (as I'd previously has a similar error; SQLException (blah blah): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection)
- IIS Website ASP.NET is v2.0.50727
- Website Authentication Methods / Enable Anonymous Access (ticked) Username: IUSR_SERVERNAME Password: *********. Intergration Windows Authentication (ticked).
- SQL Server Mngt, Secuirty / Logins / NT AUTHORITYNETWORK SERVICE lists the db in question with dbo as the Default Schema & public ticket as the db role membership.
- connectionString="Data Source=SERVERNAME;Initial Catalog=DBNAME;Integrated Security=true" providerName="System.Data.SqlClient"/>
What I've tried already based on forums advise:
- Changing Server Properties to SQL Server & Windows Authentication mode.
- Rather than using Integrated Security I've tried the SQL 'sa' account, but not 100% is I did that right (still got the same error anyway).
The rest of the advise I've read appears to confirm the rest of my settings, but I'm still getting the error.
Can anyone please shed any light on what I'm missing here. Feel free to ask questions on any configuration settings I've missed that may help.
Many thanks in advance..
View 4 Replies
View Related
Aug 4, 2015
I have a report that uses different datasets based on the year selected by a user.
I have a year_id parameter that sets a report variable named dataset_chosen. I have varified that these are working correctly together.
I have attempted populating table cell data to display from the chosen dataset. As yet to no avail.
How could I display data from the dataset a user selects via the year_id options?
View 4 Replies
View Related
Oct 28, 2006
Hi folks,
I'm having trouble getting off the ground with the Web application walkthrough "Walkthrough: Creating a Web Application Using Visual C# or Visual Basic" in VS.NET Pro 2002 [Academic] documentation. After a bit of fishing around, and consulting the MS Knowledge Base, I got the pubs database installed. I also got the connection to work well enough that the dataset would fill in the IDE.
The problem is that when I try to run the web form, either from the IDE debug menu, or by accessing the .aspx file on localhost using Firefox, I get the error:
SELECT permission denied on object 'titles', database 'pubs', owner 'dbo'.
showing in the browser.
My understanding is that this page is running as ASPNET, and I did already carry out the recommended commands to enable access:
C:>osql -E -S MY-MACHINE-NAMEVSDOTNET -Q "sp_grantlogin 'MY-MACHINE-NAMEASPNET'"
C:>osql -E -S MY-MACHINE-NAMEVSDOTNET -d Pubs -Q "sp_grantdbaccess 'MY-MACHINE-NAMEASPNET'"
both of which commands returned successfully. Any suggestions as to what else I should do to get the necessary permissions to actually display the data in my browser? Does the IIS user account need permission also?
Thanks for any insight into this vexing problem. I must say that along the way, I have had some fun exploring the osql comand-line tool. Using the -E switch, I have been able to run select and upgrade queries, but this is all pretty much fishing in the dark. I would like to get back to actually working with the walthroughs in the Visual Studio documentation.
Thanks,
Joseph
View 4 Replies
View Related
Mar 19, 2008
Hi,
When I am trying to drop a user using following statement
--First remove access from all databases
Set @SQL =
'
USE [?];
if ''' + @login_name + ''' in (Select name from sysusers )
EXEC [?].dbo.sp_revokedbaccess @name_in_db = N''' + @login_name + ''';
'
Exec sp_msforeachdb @SQL
Print 'Access Removed.'
exec @ret_value=master.dbo.sp_droplogin @login_name
I am getting an error,
User has been dropped from current database.
User has been dropped from current database.
Access Removed.
No permission to access database 'model'.
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'sysjobs', database 'msdb', owner 'dbo'.
Login dropped.
The SQL Version I am using is
-------------------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Please help me to solve this issue.
Mujeeb.
View 5 Replies
View Related
Feb 4, 2007
So any help? I tried the stuff in the FAQ
View 3 Replies
View Related
Dec 6, 2013
I would like to know if there is a way to find out who changed a users roles/access WITHOUT using the audit function. For example, if a user account was created and given SA access then changed to read only, how can I find out who made that change? I tried searching for an answer, but kept getting no results. I'm thinking this may tie into the sys.sysusers view?
View 3 Replies
View Related
