-
Permission denied....
Whne I try to create a procedure in a database , it throws an error saying
"CREATE PROCEDURE permission denied, database 'PUBS', owner 'dbo'"
Though I am a part of db_owner and ddl_admin fixed database role.
What could be the reason behind it?
-
Permission denied.... (reply)
Are you dbo of pubs?
------------
Zombie at 5/18/01 4:00:58 PM
Whne I try to create a procedure in a database , it throws an error saying
"CREATE PROCEDURE permission denied, database 'PUBS', owner 'dbo'"
Though I am a part of db_owner and ddl_admin fixed database role.
What could be the reason behind it?
-
Permission denied.... (reply)
No I am not.
------------
Ray Miao at 5/18/01 4:44:10 PM
Are you dbo of pubs?
------------
Zombie at 5/18/01 4:00:58 PM
Whne I try to create a procedure in a database , it throws an error saying
"CREATE PROCEDURE permission denied, database 'PUBS', owner 'dbo'"
Though I am a part of db_owner and ddl_admin fixed database role.
What could be the reason behind it?
-
Permission denied.... (reply)
Check if are a member of the DBO. If you are u should be able to create procedures. if you are not one go to the database properties on EM and give urself permissions to create Procedures.
------------
Zombie at 5/18/01 4:00:58 PM
Whne I try to create a procedure in a database , it throws an error saying
"CREATE PROCEDURE permission denied, database 'PUBS', owner 'dbo'"
Though I am a part of db_owner and ddl_admin fixed database role.
What could be the reason behind it?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|