Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Sorry - Dreamweaver CS3 versus SQL2005 and rights

Author  Topic  efscl Starting Member 4 Posts Posted - 2007-06-22 : 08:49:31 Hi there, i am building web apps with dreamweaver cs3 and SQL2005\Express. There you have the possibility for implementing requests on stored procedures via drag n drop. A list of all stored procedures is coming up from which i can choose. SQL2000 Here were only the self created stored procedures (on which the DB users has execute permissions) in the list. SQL2005 Here i am getting the self created stored procedures back (only these with the execute permissions). But ADDITIONAL i am getting all system procedures (sp_) back - and this is a huge list (even more than in SQL2000) the database user i am using for this has no role and only execute rights on some stored procedures. Any idea from the community? THank you very much!! Sebastian