Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grant permission to create a view

Status
Not open for further replies.
SQLWilts

SQLWilts

Programmer
Joined
Feb 12, 2001
Messages
651
Location
GB
Hi,
VERY simple question, but I have a blank today.
What security do I grant to a user so that he/she can create a view in a specific database? They have read-only access to the tables
 
Sort by date Sort by votes
Found it.
In EM, database properties/permissions tab, you have the option to allow/deny users/roles the option to create views etc
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question Question
SQL View not available to Excel Power Query
Replies
1
Views
776
dgillz
dgillz
bethabernathy
  • Locked
  • Question Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
750
dhookom
dhookom
torquinian
  • Locked
  • Question Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
738
torquinian
torquinian
baran121
  • Locked
  • Question Question
take a database from system databse place
Replies
2
Views
810
iambob
iambob
dgillz
  • Locked
  • Question Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
661
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top