Granting users ability to create a view

From: Brian Lavender <blavender_at_spk.usace.army.mil>
Date: Mon, 03 May 1999 22:09:08 GMT
Message-ID: <7gl6q1$p21$1@nnrp1.dejanews.com>

I created a database with ten tables. I created a role where the role could insert, update, delete, and update. I then granted this role to selected users. When a user tries to create a view, it is rejected. I read that the USER must have the priveledge, not granted from a role. Am I missing something? I seems like a user with priveledges granted from a role ought to be able to create a view.

brian
--

Brian E. Lavender
US Army Corps of Engineers -- Programmer / Systems Analyst Sacramento, CA (916) 557-6623

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon May 03 1999 - 17:09:08 CDT